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

• drizzle-orm

  68 25,597 9.8 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.

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• kysely

  34 11,113 8.8 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.

• postgres

  44 7,646 6.7 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

  73 4,621 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 12,422 8.1 JavaScript

  PostgreSQL client for node.js.

  (Instead of the following with pg.)

• prisma-kysely

  3 970 4.8 TypeScript

  🪄 Generate Kysely types directly from your Prisma schema!

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

• Exposed

  28 8,473 9.6 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

• Prisma

  475 40,517 9.8 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