Our great sponsors
-
kysely
Discontinued A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely] (by koskimas)
-
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.
-
ts-sql-query
Type-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.
-
MikroORM
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, MS SQL Server, PostgreSQL and SQLite/libSQL databases.
-
postgres
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
I was historically a Knex and Objection.js user. I toyed around with Prisma for a while but share some of your concerns/annoyances. I've since moved to using Kysely (the author is the same guy who started Objection.js), and I've been having a great time with it.
For what it's worth, I've been using kysely-codegen to generate the types based on the database schema and it's been working great for me.
So I'm not going to count on people ever picking it up, just straight up. I mean like I look at things like this: https://github.com/mikro-orm/mikro-orm/blob/master/packages/core/src/unit-of-work/UnitOfWork.ts and I wonder how tf is anyone other than the original author going to be able to pick it up and understand what is going on in the codebase well enough to start maintaining it themselves.
About a year ago I moved to raw SQL using Postgres.js. Honestly I thought it would be traumatic but it's been great so far.
Ha, well, as you noted, I'm wary of even bothering to comment :-), but would be great if you checked out Joist: https://joist-orm.io/