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.
TypeORM is a super popular system with a massive user base.
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Linked with Prisma ORM
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
Also if you're still looking for a storage engine I'd recommend checking out RxDB. Supports live CouchDB sync and works on both web and native.
-
Directus
Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.
Project mention: Automagically REST and GraphQL endpoints from your Azure SQL database | dev.to | 2022-01-18Directus is a Node application you can run in Azure using, for example, a container. Once it is running, you just have to configure which tables you want to expose via REST and GraphQL, configure the permission level (I'm quite sure you don't want to make all your table publicly available) and...nothing else, you're done. Of course, you can do much more, but if you don't need any additional complexity, this is really all you have to do.
-
To connect to Redis from your application, you will need a library that can perform that for you (Otherwise you have to reinvent the wheel). While I've been using IORedis for a nodeJS application in this demo, if you have been using a different language, you will have to look for different connectors like Lettuce for Java or perhaps go-redis for Go.
-
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: What are your best Node tips/tricks/discoveries from 2021? | reddit.com/r/node | 2021-12-28Here is the issue I raised: https://github.com/mikro-orm/mikro-orm/issues/602
-
Now we can consume created GraphQL API. In the GitHub Repo same functionality has been added with REST approach and GraphQL endpoint. Also widely used Swagger configured for Web API Endpoints as well as AltairUI added for GraphQL endpoint testing. Naturally, AltairUI it not a must for GraphQL, you can also use Swagger, GraphiQL, or GraphQL Playground.
-
OPS
OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.
-
Project mention: Component Is Not Updating After Vuex State Change | reddit.com/r/vuejs | 2021-02-08
What about this? https://github.com/vuejs/vuefire/issues/999
-
Project mention: Recovering XAMPP developer looking to make a Node CRUD app. What Node database tools are easy to learn? | reddit.com/r/node | 2021-12-30
When I need CRUD-like interaction with application clients I use Graphile, which serves a GraphQL server based on your Postgres schema. My service layers more often use Slonik for highly customized queries and the elusive SQL syntax highlighting in Node/TypeScript.
-
rowy
Open-source Airtable-like experience for your database (Firestore) with GCP's scalability. Build any automation or cloud functions for your product. ⚡️✨
Project mention: Rowy - Airtable-like simplicity for managing your Firestore data, Opensource alternative to Airtable | reddit.com/r/programming | 2021-12-22 -
Project mention: Recovering XAMPP developer looking to make a Node CRUD app. What Node database tools are easy to learn? | reddit.com/r/node | 2021-12-30
In addition, I'd recommend using Sequelize Auto:
-
express-typescript-boilerplate
A delightful way to building a RESTful API with NodeJs & TypeScript by @w3tecch
Project mention: Standard Typescript Tutorial with Express and an ORM or ODM | reddit.com/r/node | 2021-06-18I would suggest to look for "boilerplate" with all tech u want to learn, than combine few tutorials to move forward ur knowledge and build something around that... Here is one example: https://github.com/w3tecch/express-typescript-boilerplate
-
-
CloudBeaver's integrated schema diagrams\ Released around the same time as Beekeeper Studio, CloudBeaver is a smaller, open-source project supported by a stable of thirteen contributors. Because of this, development schedules are a little more deliberate, but that hasn't stopped CloudBeaver from fine-tuning its lightweight, user-friendly GUI. The interface is clean and has both dark and light modes. CloudBeaver also presents users with informative visualizations, keeping you engaged and organized as databases scale. Being a web application, this tool is accessible to a larger subset of users without consuming too many resources or disk space.
-
Another great option (and potentially better than the first) is ElectroCRUD: https://github.com/garrylachman/ElectroCRUD. Unfortunately I don't have first-hand experience with this either, so it's still hearsay but worth a look.
-
Project mention: Ask HN: Why is there no Django/Rails equivalent in JavaScript world? | news.ycombinator.com | 2021-10-14
Layr.js is trying to take on something in this middle space. It basically hides either end from you and is still hard to reason about. Only mongodb is supported now. And yes I much prefer the option of having many community made packages over one supported way.
-
You’ll probably want something like this too: https://github.com/salsita/node-pg-migrate
-
Now I will explain two things that I think are fundamental about the library we are going to use (typeorm-seeding).
-
Postgres in the browser is possible through pg-mem: "pg-mem is an experimental in-memory emulation of a postgres database" but it also suffers from no persistence. If you can persist to a file somewhere then read it in on startup (and if your local data isn't huge) this might work.
-
client-side-databases
An implementation of the exact same app in Firestore, AWS Datastore, PouchDB, RxDB and WatermelonDB
-
Project mention: EventReduce optimizes database queries that run multiple times | news.ycombinator.com | 2021-12-21
-
-
Their official Typescript client is well maintained and quite powerful, it would be very useful in an eventual integration with Prisma.
TypeScript Database related posts
- Started 2022 by updating portfolio website
- Eagle + sleeping pill, I have a T-rex on turn 7, 4 rounds before it becomes available
- Setting up a basic TypeORM starter
- Timeline view with all previous journal entries?
- How to Seed Database using TypeORM Seeding
- Krishi Bazaar
- What ORM to use with TypeScript
Index
What are some of the best open-source Database projects in TypeScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | TypeORM | 26,853 |
| 2 | Prisma | 19,685 |
| 3 | RxDB | 16,895 |
| 4 | Directus | 13,455 |
| 5 | Redis | 9,841 |
| 6 | MikroORM | 3,981 |
| 7 | altair | 3,876 |
| 8 | vuefire | 3,231 |
| 9 | slonik | 2,926 |
| 10 | rowy | 2,564 |
| 11 | sequelize-auto | 2,520 |
| 12 | express-typescript-boilerplate | 2,326 |
| 13 | denodb | 1,583 |
| 14 | cloudbeaver | 1,395 |
| 15 | ElectroCRUD | 1,351 |
| 16 | layr | 1,206 |
| 17 | node-pg-migrate | 997 |
| 18 | typeorm-seeding | 704 |
| 19 | pg-mem | 691 |
| 20 | client-side-databases | 655 |
| 21 | event-reduce | 630 |
| 22 | Iridium | 568 |
| 23 | arangojs | 535 |
Are you hiring? Post a new remote job listing for free.
