Top 23 TypeScript Database Projects
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDBProject mention: Startchart: Prisma Schema | dev.to | 2023-02-03
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 - 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!
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-31
I 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.
🚀 A robust, performance-focused, and full-featured Redis client for Node.js.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,
The Official MongoDB Node.js DriverProject mention: How does one set up MongoDB using "vanilla" JS? | reddit.com/r/mongodb | 2022-08-19
The Open Source Firebase Alternative with GraphQL.Project mention: Is there smth like firebase on-prem? | reddit.com/r/Firebase | 2023-01-25
You can use Nhost (100% open source): https://github.com/nhost/nhost/tree/main/examples/docker-compose
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
✨⚡️ A beautiful feature-rich GraphQL Client for all platforms. (by altair-graphql)Project mention: Public Angular Project | reddit.com/r/angular | 2022-05-08
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)
A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.Project mention: Kysely: TypeScript SQL Query Builder | news.ycombinator.com | 2023-01-24
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
Grist is the evolution of spreadsheets.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
A type-safe typescript SQL query builderProject mention: Announcing a new TypeScript ORM | reddit.com/r/typescript | 2023-02-04
prisma (mentioned in the article), zapatos, pgtyped and kysely are the most popular currently I think.
🔥 Firebase bindings for Vue.jsProject mention: VueFire CRUD | Vue 3 | Firebase Auth | dev.to | 2023-01-19
We will use VueFire that exposes some helpful composables to easily achieve things like authentication and real-time data sync.
A delightful way to building a RESTful API with NodeJs & TypeScript by @w3tecch
Automatically generate bare sequelize models from your database.
App to easily query, script, and visualize data from every database, file, and API.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.
A desktop application for viewing and analyzing tabular data
Cloud Database ManagerProject mention: WAL Mode in LiteFS | news.ycombinator.com | 2023-01-04
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, Datasette or sqlite-web 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.
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for DenoProject mention: MariaDB API Recomendations | reddit.com/r/Deno | 2022-09-29
Database CRUD Application Built on Electron | MySQL, Postgres, SQLiteProject mention: After few years, ElectroCRUD is coming back | reddit.com/r/opensource | 2023-01-19
development branch: https://github.com/garrylachman/ElectroCRUD/tree/develop
A system design tool that allows you to simulate data flow of distributed systems.
An in memory postgres DB instance for your unit tests
Dramatically simplify full‑stack developmentProject mention: Layr v2 Is Out, but You May Never Use It | dev.to | 2023-01-12
Finally, after two years of hard work, Layr v2 is out.
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.
TypeScript Database related posts
Announcing a new TypeScript ORM
2 projects | reddit.com/r/typescript | 4 Feb 2023
Before and after pics, i re-indexed my vault (600) notes for dataview which created prominent MOC's and clusters
1 project | reddit.com/r/ObsidianMD | 4 Feb 2023
Open-source Desktop App written in Golang and React.
1 project | reddit.com/r/opensource | 4 Feb 2023
Startchart: Prisma Schema
2 projects | dev.to | 3 Feb 2023
Announcing a new TypeScript ORM
2 projects | dev.to | 3 Feb 2023
Prisma adds support for multiple schemas and table views!!
1 project | reddit.com/r/Supabase | 2 Feb 2023
Anyone has any info on DataCore?
2 projects | reddit.com/r/ObsidianMD | 1 Feb 2023
A note from our sponsor - Sonar
www.sonarsource.com | 4 Feb 2023
What are some of the best open-source Database projects in TypeScript? This list will help you: