Our great sponsors
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
-
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.
-
postgres-schema-builder
Simple postgres schema builder for Node.JS leveraging Typescript's type system to enable typesafe queries
If you prefer to work on a lower level of abstraction than an ORM (i.e., plain SQL) and ensure type-safety on your DB layer, I'd recommend to check out a tool like Slonik or pgtyped :)
The TLDR is: - we grew the team and built out proper Product and Engineering teams - our entire engineering process is happening on GitHub - we regularly triage and prioritize all the issues in our GitHub repo (typically within 1-2 days) - we have a public roadmap that provides insights into the features that are planned over the next couple of months - we issue new releases with new features and improvements every two weeks - our Slack is incredibly active and we make sure to help all users that raise questions there (plus we have lots of community members that are helping each other our as well) - you can ask questions and initiate conversations about Prisma via GitHub discussions
That's fair! FWIW, I don't think you get that kind of certainty with any open source tools? TypeORM had a crazy boost in popularity when it was released and after ~2 years of intense development it was basically dropped and now has a very unclear future. And I don't have a crystal ball to see what's going to happen to Prisma, I just know that we have an amazing team and things are looking incredibly good at the moment. But can I guarantee you that the Prisma open source tools with be around in their current form in 10 years? Nope, in the same way that I can't make these guarantees about any other OSS tools.
Two years ago, I started publishing the code on GitHub (postgres-schema-builder, current version is 1.2.0-beta.3). The code has been in our production code for over 3 years now (and I'm also using it for several private side projects), but our team is currently working on a brand new library! The idea stays the same as for the postgres-schema-builder: You define your database schema and get the corresponding interface types derived from the schema (without code generation). Further, you can perform typesafe SQL queries against your defined schema. With the upcoming library, we plan to even allow more complex queries like joins, aggregations, database views, etc..., all typesafe, all functional API! I hope we are able to release a first beta version in about 1-2 months. I will keep you up to date!
The key feature of both postgres-schema-builder and our new library is the database schema definition and the derived typesafe queries. You define your whole (table) schema in typescript (example can be seen here) and for each Table you automatically receive a derived typescript type which reflects the correct column names and data types. You also get typesafe queries, like inserts, updates, selects, etc...
Maybe typesafe-query-builder is worth a look.