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! Learn more →
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.
A alternative to Tableau
-
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
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.
-
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-25My 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.
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!
-
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
-
Project mention: Drizzle-team/drizzle-ORM: TypeScript ORM for SQL | news.ycombinator.com | 2023-03-06
-
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? https://github.com/eveningkid/denodb
-
development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop
-
-
lucid
AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more (by adonisjs)
When I started this project I was inspired by Lucid which is the ORM of the Adonis.js framework.
-
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.
-
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.
-
-
At Databases because you don't need ORM.
-
Project mention: Singlelink VS littlelink-custom - a user suggested alternative | libhunt.com/r/Singlelink | 2022-05-03
-
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-10If 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.
-
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.
TypeScript MySQL related posts
- My Installed App as Developer
- Kysely: A type-safe SQL query builder for Typescript by the author of objection.js
- New schema-based ORM for rapid and accurate data modeling
- Neuledge: A schema-based ORM for rapid and accurate data modeling
- New schema-based ORM for rapid and accurate data modeling
- New schema-based ORM for rapid and accurate data modeling
- New schema-based ORM for rapid and accurate data modeling
-
A note from our sponsor - Appwrite
appwrite.io | 1 Apr 2023
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 |