TypeScript MySQL

Open-source TypeScript projects categorized as MySQL
Edit details
Topics: TypeScript Postgresql Database SQL Sqlite
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

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: Grafana: From Dashboards to Centralized Observability | news.ycombinator.com | 2024-05-06

  • Strapi

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

    • Project mention: Javascript Ecosystem, How Trash It Actually Is? | dev.to | 2024-05-14

    Strapi is a Headless CMS built with TypeScript. It has a backend and a frontend. Just take a look at how many configuration files it has just for running the project.

  • 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: A Software Engineer's Tips and Tricks #1: Drizzle | dev.to | 2024-04-29

    In the world of software development, there are two kinds of developers: those who have never had to complain about ORMs and those who have actually used them. Whether it’s Django ORM for Python, Active Record for Ruby, GORM for Golang, Doctrine for PHP, or Prisma for TypeScript, a common issue persists: writing simple queries is straightforward, but constructing complex or optimized queries can take hours, if not days.

  • 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: Show HN: Tsynamo – Type-friendly DynamoDB query builder for TypeScript | news.ycombinator.com | 2024-04-10

    Hello HN! I was recently introduced to Kysely (https://github.com/kysely-org/kysely), a type-safe Typescript SQL query builder, and instantly fell in love! I got inspired and wanted to make something similar for AWS DynamoDB.

    Thus, I developed Tsynamo! Instead of calling it type-safe, I decided to go with type-friendly, because the library is still in an early stage, and is not 100% type-safe.

    Under the hood, Tsynamo compiles the built queries into AWS SDK v3 commands. I feel that Tsynamo simplifies the AWS SDK API quite a lot since the developer doesn't have to mess around with condition/filter expressions or attribute names/values themselves, and as a bonus gets autocompletion for building the queries!

    There's also a playground to test it out in your browser: https://try.tsynamo.dev. It might not have the most up-to-date API of the library in use yet, but you can get the library's main idea from there.

    Since the project is still in its early stages, it doesn't yet have 100% support for all DynamoDB features, like querying indexes. The next steps will be increasing the support coverage and perhaps adding automatic type generation as inspired by kysely-codegen (https://github.com/RobinBlomberg/kysely-codegen).

    Would love to get some feedback, thanks in advance!

  • 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 | 15 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,624
2 Strapi 60,474
3 nocodb 42,702
4 Prisma 37,436
5 TypeORM 33,430
6 Hasura 30,851
7 Sequelize 29,076
8 Directus 25,581
9 drizzle-orm 20,089
10 beekeeper-studio 15,348
11 kysely 9,372
12 MikroORM 7,202
13 sqlchat 3,765
14 datastation 2,854
15 Keyv 2,491
16 dokploy 3,196
17 1Backend 2,153
18 denodb 1,909
19 database-js 1,155
20 schemats 1,024
21 nextjs-postgres-auth-starter 824
22 prisma-editor 684
23 @databases 588

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