Drizzle is just as unready for prime-time as Prisma, what else is there?

• drizzle-orm

  47 19,712 9.7 TypeScript

  Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

  

I myself ran into some issues when I started using drizzle with mysql. They had issues in the way they were handling datetime types. At the time I just used workarounds but then decided to submit a PR since the solution was pretty simple. I just liked drizzle's approach so much that I ended up committing more PRs. At this point, I'm one of the mayor contributors of the library. I think that we have to give some leeway to OSS libraries. Managing OSS is not easy, everybody's issues are important and mayor to them, but there's just so many hours in the day to work for free (or very little). At the end of the day, it's just software prone to have issues.

• kysely

  26 9,289 9.3 TypeScript

  A type-safe typescript SQL query builder

  

I've switched to kysely (https://kysely.dev) to just build SQL instead and it's nice to have full SQL access but still be type safe to my schema. Enjoying it so far.

• SurveyJS

  surveyjs.io sponsored

  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.

  

• postgres

  42 6,704 8.2 JavaScript

  Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)

I'd push you to consider using postgres, slonik or similar for database queries. With these libraries, you just write SQL, but they perform input sanitization for you. So you can safely write:

• slonik

  71 4,381 9.2 TypeScript

  A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

I'd push you to consider using postgres, slonik or similar for database queries. With these libraries, you just write SQL, but they perform input sanitization for you. So you can safely write:

• PostgreSQL

  57 11,907 8.0 JavaScript

  PostgreSQL client for node.js.

(Instead of the following with pg.)

• prisma-kysely

  3 790 6.9 TypeScript

  🪄 Generate Kysely types directly from your Prisma schema!

You can just use prisma for migrations. check out prism-kysely

• Exposed

  28 7,879 9.5 Kotlin

  Kotlin SQL Framework

  

So is it like Exposed for Kotlin which is a typesafe Kotlin DSL for building sql queries? I’ve been looking for something like this in typescript! https://github.com/JetBrains/Exposed

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• Prisma

  442 37,151 9.9 TypeScript

  Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

  

Worth to look at new preview features in prisma 5.7 (relationJoins & distinct): https://github.com/prisma/prisma/releases/tag/5.7.0

Suggest a related project