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: Church dropping wards left and right | reddit.com/r/exmormon | 2023-04-01

    A alternative to Tableau

  • nocodb

    🔥 🔥 🔥 Open Source Airtable Alternative

    Project mention: Retool Database | news.ycombinator.com | 2023-03-30

    Congrats. Looks like it will be useful for plenty of folks. Can you outline how it compares with e.g. NocoDB [0] and others mentioned in another comment [1]?

    As for "getting started" speed and general data tinkering, I find little beats Gnumeric -> CSV -> SQLite query [2] although I appreciate that solo developers aren't your target market :)

    [0] https://github.com/nocodb/nocodb

    [1] https://news.ycombinator.com/item?id=35381252

    [2] https://til.simonwillison.net/sqlite/one-line-csv-operations

  • SurveyJS

    Extensible JavaScript Form Builder Libraries. SurveyJS is a set of four fully customizable JS libraries that allow you to create, easily modify, and run multiple web forms in any web app, while retaining all sensitive data on your own servers.

  • 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: Automatizando la generación de datos ficticios con Seed, Factory, Faker y TypeORM en NestJS | dev.to | 2023-03-31
  • Prisma

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

    Project mention: Programming is the art of trade-off | dev.to | 2023-04-01

    Add findManyAndCount to return count of queried items #7550

  • Hasura

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

    Project mention: Fara job de 6 luni | reddit.com/r/programare | 2023-03-28
  • 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: Choosing a good hosting provider for freelance clients | reddit.com/r/webdev | 2023-03-25

    My sites are "built" offline and deployed 100% static. Astro is my current favorite for this. Nuxt3 is another that I like to use. When I need a CMS, I like Directus - I have my own self-hosted instance on DigitalOcean.

  • MikroORM

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

    Project mention: MikroORM v6 gets a strict partial loading support | reddit.com/r/node | 2023-03-04

    More about v6 development can be found here.

  • Appwrite

    Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!

  • kysely

    A type-safe typescript SQL query builder (by kysely-org)

    Project mention: Kysely: A type-safe SQL query builder for Typescript by the author of objection.js | reddit.com/r/programming | 2023-03-28

    Really enjoyed reading through the code base. After browsing for a while, I also got a good laugh at the comment at the top of: https://github.com/kysely-org/kysely/blob/master/src/plugin/with-schema/with-schema-transformer.ts

  • drizzle-orm

    TypeScript ORM for SQL

    Project mention: Drizzle-team/drizzle-ORM: TypeScript ORM for SQL | news.ycombinator.com | 2023-03-06
  • datastation

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

    Project mention: Code coverage for Go integration tests | news.ycombinator.com | 2023-03-08

    There was a technique that existed already where you could use `go test -cover` and the `-o` flag to produce a binary from `go test` rather than actually running tests. So you could build a binary that had coverage enabled. Then when you ran

    Here's an example: https://github.com/multiprocessio/datastation/blob/main/runn....

    I can't remember where I found this technique but it's been around for a while.

    This new option is the same thing but a way to `go build` with `-cover` instead of `go test -cover -o $out`? Do I have that right?

  • 1Backend

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

    Project mention: Why would someone need serverless infrastructure? | reddit.com/r/homelab | 2023-01-08
  • denodb

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

    Project mention: MariaDB API Recomendations | reddit.com/r/Deno | 2022-09-29

    denoDB? https://github.com/eveningkid/denodb

  • ElectroCRUD

    Database CRUD Application Built on Electron | MySQL, Postgres, SQLite

    Project mention: After few years, ElectroCRUD is coming back | reddit.com/r/opensource | 2023-01-19

    development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop

  • schemats

    Generate typescript interface definitions from SQL database schema

  • lucid

    AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more (by adonisjs)

    Project mention: Moving MyUnisoft Node.js back to TypeORM | dev.to | 2022-08-02

    When I started this project I was inspired by Lucid which is the ORM of the Adonis.js framework.

  • magic

    Generate a web app in seconds with Low-Code and AI (by polterguy)

    Project mention: Open Source ChatGPT based Bing Search launched | dev.to | 2023-02-11

    If you like this, I would appreciate if you share it with your friends on Facebook, Twitter, LinkedIn, Reddit, "whatever". And if you've got questions, feel free to contact us. You're of course free to download the open source version, but if you want a rapid 5 minutes setup, the simplest is to signup below, at which point we'll take care of hosting, security, and almost all problems that might popup as you play around with things.

  • database-js

    A Fetch API-compatible PlanetScale database driver

    Project mention: Postgres over WebSocket | news.ycombinator.com | 2022-12-08

    That I understand.

    But of course for the user of the driver it might be fine if that is 2 or more HTTP requests. I expect that is how PlanetScale does it in their transaction implementation, https://github.com/planetscale/database-js#transactions, and I know that is how Prisma Data Proxy handles it - the transaction is identified with an ID which is returned to the Client and then included in further requests for the same transaction.

    It's valid tradeoff to make to prefer a persistent connection to keep the overhead for multiple queries in a transaction as low as possible - which seems what Neon has done here.

  • deno-nessie

    A modular Deno library for PostgreSQL, MySQL, MariaDB and SQLite migrations

  • @databases

    TypeScript clients for databases that prevent SQL Injection

    Project mention: Node Core Dev Starter Kit | dev.to | 2022-10-21

    At Databases because you don't need ORM.

  • sql-lint

    An SQL linter

    Project mention: sql-lint - A linter for SQL (finally hits version 1.0.0) | reddit.com/r/coolgithubprojects | 2022-06-24
  • sql-template-tag

    ES2015 tagged template string for preparing SQL statements, works with `pg` and `mysql`

    Project mention: Knex Raw SQL String SQL Highlighting VS Code and best practices to avoid SQL Injection Attack? | reddit.com/r/node | 2022-04-10

    If you prefer SQL and you use postgres you can check out slonik. If you want to keep using knex you can use https://github.com/blakeembrey/sql-template-tag. They will add placeholders for all the values and expose helper for query building via strings (e.g. a special join). At the same time they are typesafe.

  • kysely-planetscale

    A Kysely dialect for PlanetScale Serverless

    Project mention: Kysely: a type-safe SQL query builder for TypeScript | reddit.com/r/typescript | 2023-03-26

    And if you do decide to write your own integration here's the full source code of kysely-planetscale (about 160 LOC) https://github.com/depot/kysely-planetscale/blob/main/src/index.ts

  • InfluxDB

    Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

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). The latest post mention was on 2023-04-01.

TypeScript MySQL related posts

Index

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

Project Stars
1 Grafana 54,665
2 nocodb 35,140
3 TypeORM 30,865
4 Prisma 30,018
5 Hasura 29,483
6 Directus 20,738
7 MikroORM 5,750
8 kysely 4,378
9 drizzle-orm 3,263
10 datastation 2,694
11 1Backend 2,116
12 denodb 1,881
13 ElectroCRUD 1,457
14 schemats 990
15 lucid 872
16 magic 802
17 database-js 596
18 deno-nessie 516
19 @databases 512
20 Singlelink 421
21 sql-lint 395
22 sql-template-tag 240
23 kysely-planetscale 231
Write Clean JavaScript Code. Always.
Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
www.sonarsource.com