TypeScript MySQL

Open-source TypeScript projects categorized as MySQL

Top 23 TypeScript MySQL Projects

  • Grafana

    The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.

  • Project mention: Using Cloud Monitoring to Monitor IRIS-Based Applications Deployed in GKE | dev.to | 2024-05-23

    In this article, we’ll look at one of the ways to monitor the InterSystems IRIS data platform (IRIS) deployed in the Google Kubernetes Engine (GKE). The GKE integrates easily with Cloud Monitoring, simplifying our task. As a bonus, the article shows how to display metrics from Cloud Monitoring in Grafana.

  • Strapi

    πŸš€ Strapi is the leading open-source headless CMS. It’s 100% JavaScript/TypeScript, fully customizable and developer-first.

  • Project mention: Deploy Strapi as a Content Backend and Headless CMS | dev.to | 2024-05-27

    Strapi is a headless CMS that helps you build content-based sites with the frontend of your choice by providing a reliable, customizable API backend. Strapi allows you to define your own content types, includes a feature-rich admin panel, and provides all of the building blocks you need to develop a comprehensive editing and publication workflow.

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo
  • nocodb

    πŸ”₯ πŸ”₯ πŸ”₯ Open Source Airtable Alternative

  • Project mention: Open-Source Alternative to Airtable | news.ycombinator.com | 2024-05-01
  • Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

  • Project mention: PHP: Laravel, Ruby: Rails, JavaScript:? | dev.to | 2024-05-28

    While it may not have reached the level of Laravel or Rails, the current efforts in the JS world have recognized this issue. If you look at the toolkit of the solution mentioned above, you'll find a common name: Prisma

  • TypeORM

    ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

  • Project mention: NodeJS Security Best Practices | dev.to | 2024-02-19

    If you use Sequalize, TypeORM or for MongoDB, we have Mongoose these types of ORM tools, then you are safe by default because these help us against the SQL query injection attacks by default.

  • Hasura

    Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.

  • Project mention: Serious flaws in SQL – Edgar F. Codd (1990) | news.ycombinator.com | 2024-04-25

    > 2. ORMs do not hide SQL nastiness.

    This is certainly true!

    I mean: ORMs are now well known to "make the easy queries slightly more easy, while making intermediate queries really hard and complex queries impossible".

    I think the are of ORMs is over. It simply did not deliver.

    If a book on SQL is --say-- 100 pages, a book on Hibernate is 400 pages. So much to learn just to make the easy queries slightly easier to type? Just not worth it.

    I prefer jooq any day over ORMs. And dont get me started over what tools like Hasuna have to offer.

    There are also some languages (forgot the names) that are SQL-done-right. Select in the back, more type safe, more logic, more in the same steps as the query gets executed. These need to be adopted by PG and MySQL and we're good to go. (IMHO)

    https://www.jooq.org/

    https://hasura.io/

  • Sequelize

    Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.

  • Project mention: Full Stack Web Development Concept map | dev.to | 2024-03-23

    Sequelize - modern Typescript and NodeJS ORM for Oracle, Postgres, MySQL, MariaDB, SQLite, SQL Server+docs

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • Directus

    The Modern Data Stack 🐰 β€” Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.

  • Project mention: How to Deploy Directus as a Backend-as-a-Service (BaaS) on Koyeb | dev.to | 2024-04-25

    Directus is an open data platform built to serve as a headless CMS, API, or Backend-as-a-Service (BaaS) for other applications. It is designed to make data accessible to people of all technical levels and to make it easy to build data-centric applications. Directus is extensible and can be integrated with many different frontend technologies to create stable, well-structured development and user experiences.

  • drizzle-orm

    Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too πŸ˜…

  • Project mention: A Software Engineer's Tips and Tricks #1: Drizzle | dev.to | 2024-04-29

    Enter Drizzle, a lightweight typesafe ORM for TypeScript that comes with one promise: If you know SQL β€” you know Drizzle.

  • beekeeper-studio

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

  • Project mention: Using migrations with Golang | dev.to | 2024-04-17

    If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

  • kysely

    A type-safe typescript SQL query builder

  • Project mention: Swift sucks at web serving or does it? | news.ycombinator.com | 2024-05-15

    The most interesting JS DB lib I came across was https://github.com/kysely-org/kysely but still didn't feel as good as EF Core.

  • MikroORM

    TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.

  • Project mention: Rust GraphQL APIs for NodeJS Developers: Introduction | dev.to | 2024-02-08

    In my usual NodeJS tech stack, which includes GraphQL, NestJS, SQL (predominantly PostgreSQL with MikroORM), I encountered these limitations. To overcome them, I've developed a new stack utilizing Rust, which still offers some ease of development:

  • sqlchat

    Chat-based SQL Client and Editor for the next decade

  • Project mention: FLaNK Stack Weekly 12 February 2024 | dev.to | 2024-02-12
  • datastation

    App to easily query, script, and visualize data from every database, file, and API.

  • Keyv

    Simple key-value storage with support for multiple backends

  • dokploy

    Open Source Alternative to Vercel, Netlify and Heroku.

  • Project mention: FLaNK-AIM Weekly 13 May 2024 | dev.to | 2024-05-13
  • 1Backend

    Run your web apps easily with a complete platform that you can install on any server. Build composable microservices and lambdas.

  • denodb

    MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno

  • Project mention: denodb VS denodata - a user suggested alternative | libhunt.com/r/denodb | 2023-11-29
  • database-js

    A Fetch API-compatible PlanetScale database driver

  • schemats

    Generate typescript interface definitions from SQL database schema

  • nextjs-postgres-auth-starter

    Next.js + Tailwind + Typescript + Drizzle + NextAuth + PostgreSQL starter template.

  • prisma-editor

    Prisma Editor - A powerful tool to visualize and edit Prisma Schema.

  • @databases

    TypeScript clients for databases that prevent SQL Injection

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

TypeScript MySQL related posts

  • Open-Source Alternative to Airtable

    1 project | news.ycombinator.com | 1 May 2024
  • A Software Engineer's Tips and Tricks #1: Drizzle

    3 projects | dev.to | 29 Apr 2024
  • Get started with Drizzle ORM and Xata's Postgres service

    1 project | dev.to | 16 Apr 2024
  • Show HN: Tsynamo – Type-friendly DynamoDB query builder for TypeScript

    3 projects | news.ycombinator.com | 10 Apr 2024
  • πŸͺΈ6 Text2SQL Tools to Write Stunning SQL for you β˜„οΈ

    5 projects | dev.to | 4 Feb 2024
  • ORMs are nice but they are the wrong abstraction

    7 projects | news.ycombinator.com | 1 Feb 2024
  • Drizzle TypeScript ORM

    1 project | news.ycombinator.com | 31 Jan 2024
  • A note from our sponsor - SaaSHub
    www.saashub.com | 28 May 2024
    SaaSHub helps you find the best software and product alternatives Learn more β†’

Index

What are some of the best open-source MySQL projects in TypeScript? This list will help you:

Project Stars
1 Grafana 60,851
2 Strapi 60,895
3 nocodb 43,028
4 Prisma 37,611
5 TypeORM 33,478
6 Hasura 30,859
7 Sequelize 29,111
8 Directus 25,717
9 drizzle-orm 20,398
10 beekeeper-studio 15,420
11 kysely 9,488
12 MikroORM 7,238
13 sqlchat 3,902
14 datastation 2,856
15 Keyv 2,493
16 dokploy 3,528
17 1Backend 2,154
18 denodb 1,909
19 database-js 1,153
20 schemats 1,024
21 nextjs-postgres-auth-starter 828
22 prisma-editor 697
23 @databases 590

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com