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. Learn more →
Top 23 TypeScript Database Projects
-
TypeORM
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
This week, I focus on creating an initial schema for the project through using Prisma. This is for a MySQL database, and the PR for the initial schema is 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!
-
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: Looking for a stupid simple CMS solution for static pages! | reddit.com/r/Frontend | 2023-01-31I prefer https://directus.io/ because Strapi STILL cannot re-order collections.
-
I am using rxdb which internally uses some folder imports like import x from './folder' as opposed to import x from './folder/index.js which is big nono inside node.js environments.
-
Project mention: Help implementing Heroku Data For Redis (+bull & throng) / `ioredis` | reddit.com/r/Heroku | 2022-11-25
In order to try and mitigate the OOMs. I read the Background Jobs in Node.JS with Redis blog post and implemented Heroku Data For Redis with ioredis, BullMQ and Throng,
-
Project mention: How does one set up MongoDB using "vanilla" JS? | reddit.com/r/mongodb | 2022-08-19
The MongoDB JavaScript driver uses and requires node.js, which is what 99.9% of server-side JavaScript implementations use.
-
You can use Nhost (100% open source): https://github.com/nhost/nhost/tree/main/examples/docker-compose
-
Sonar
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.
-
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: RFC: Remove `persist`/`flush` from repository level in MikroORM v6 | reddit.com/r/node | 2023-01-31 -
However, it's not an Angular app, if you are looking for an app instead of library, you can check Altair app: https://github.com/altair-graphql/altair/tree/master/packages/altair-app or angular sptify, https://github.com/trungk18/angular-spotify/tree/main/libs/web (Uses NX monorepos to maintain the libraries)
-
I think this is a really cool project, but for most use cases (not all, but most) I strongly believe query builders are an anti-pattern. I could go over the reasons, but when I saw this blog post, https://gajus.medium.com/stop-using-knex-js-and-earn-30-bf41..., from the author of slonik years ago I had a eureka moment, and it explains the reasoning better than I could.
Template strings in TypeScript allow you to safely write SQL directly, still with type checking: https://github.com/gajus/slonik#readme
-
Project mention: irelia VS grist-core - a user suggested alternative | libhunt.com/r/irelia | 2023-02-03
Irelia is an unauthorized clone of Grist. https://twitter.com/fitzyfitzyfitzy/status/1563273434612002817
-
prisma (mentioned in the article), zapatos, pgtyped and kysely are the most popular currently I think.
-
We will use VueFire that exposes some helpful composables to easily achieve things like authentication and real-time data sync.
-
express-typescript-boilerplate
A delightful way to building a RESTful API with NodeJs & TypeScript by @w3tecch
-
-
Project mention: Engineers using dbt with VS Code - how are you previewing your results in lieu of the functionality provided by dbt cloud? | reddit.com/r/dataengineering | 2022-06-29
If my employer doesn't consider paying for dbt cloud, I will use u/eatonphil 's datastation, run the queries on a dev database then put them in dbt.
-
Since this is about CSV, this is obligatory tool for larger ones:
-
Hi, author of litexplore here!
I agree remote management is the "least convenient" aspect of SQLite. If you have control over the remote VM where the DB is hosted, you can also run something like ClouDBeaver[0], Datasette[1] or sqlite-web[2] as a Docker container, then connect to it from your laptop.
The reason I wrote litexplore was that those approaches require exposing extra ports, managing authentication, etc. With litexplore, you just need the sqlite3 CLI (compiled with the JSON1 extension) installed in the VM and a way to access it over SSH.
litexplore is still in early stages and I have some updates planned in the following 2 months, but the basics are working.
-
denoDB? https://github.com/eveningkid/denodb
-
development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop
-
-
I was wondering the other day how to classify tests that use a test double like pg-mem, which isn't a mock but isn't the Dockerized test DB either :
-
Finally, after two years of hard work, Layr v2 is out.
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
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-02-04.
TypeScript Database related posts
- Announcing a new TypeScript ORM
- Before and after pics, i re-indexed my vault (600) notes for dataview which created prominent MOC's and clusters
- Open-source Desktop App written in Golang and React.
- Startchart: Prisma Schema
- Announcing a new TypeScript ORM
- Prisma adds support for multiple schemas and table views!!
- Anyone has any info on DataCore?
-
A note from our sponsor - Sonar
www.sonarsource.com | 4 Feb 2023
Index
What are some of the best open-source Database projects in TypeScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | TypeORM | 30,280 |
| 2 | Prisma | 28,710 |
| 3 | Directus | 19,569 |
| 4 | RxDB | 18,717 |
| 5 | Redis | 11,669 |
| 6 | MongoDB | 9,661 |
| 7 | nhost | 5,958 |
| 8 | MikroORM | 5,547 |
| 9 | altair | 4,580 |
| 10 | slonik | 3,627 |
| 11 | grist-core | 3,606 |
| 12 | kysely | 3,526 |
| 13 | vuefire | 3,466 |
| 14 | express-typescript-boilerplate | 2,839 |
| 15 | sequelize-auto | 2,730 |
| 16 | datastation | 2,660 |
| 17 | tad | 2,584 |
| 18 | cloudbeaver | 2,020 |
| 19 | denodb | 1,860 |
| 20 | ElectroCRUD | 1,442 |
| 21 | Systemizer | 1,278 |
| 22 | pg-mem | 1,216 |
| 23 | layr | 1,214 |
Build time-series-based applications quickly and at scale.
InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
www.influxdata.com