drizzle vs prisma reddit - Brave Search

Drizzle vs Prisma: Which One to Choose?

reddit.com › r › nextjs › comments › 1p0e5tk › drizzle_vs_prisma_which_one_to_choose

Took the one you are comfortable with. In the end both does the same job: Interrogating the database for data.. Answer from VirtualSingularity on reddit.com

reddit.com › r/nextjs › drizzle vs prisma: which one to choose?

r/nextjs on Reddit: Drizzle vs Prisma: Which One to Choose?

November 18, 2025 -

Hey all,
which ORM do you prefer to use in Next.js Drizzle ORM or Prisma and why?

I kept going back and forth between the two for a while, so I wrote a deep-dive comparison to help anyone else who’s stuck deciding instead of actually building their product.

In the end, I went with Drizzle since I’m pretty comfortable with SQL and really like how lightweight it is.

Full read: https://medium.com/@codabu/drizzle-vs-prisma-choosing-the-right-typescript-orm-in-2026-deep-dive-63abb6aa882b

Took the one you are comfortable with. In the end both does the same job: Interrogating the database for data..

I know SQL, but I'm faster with Prisma. ORM and autocomplete with TypeScript make everything super fast. I really like defining the data model with Prisma schemas. Migrations work pretty well.

Drizzle - An ORM that lets you just write SQL Mar 15, 2023

r/node

3y ago

Current opinion on Prisma? Jul 26, 2024

r/node

2y ago

Prisma vs Drizzle in 2024? Has prisma gotten any better in the recent months? Dec 27, 2023

r/nextjs

2y ago

Question about Drizzle ORM Aug 11, 2025

r/node

11mo ago

Drizzle ORM-typesafe alternative to knex/prisma Jan 19, 2023

r/node

3y ago

More results from reddit.com

reddit.com › r/node › prisma 7 vs drizzle

r/node on Reddit: Prisma 7 vs Drizzle

January 1, 2026 -

Now that Prisma 7 comes out, boosting its performance by removing the Rust engine, which one is better in your opinion and why?

I really enjoy that drizzle works with native TS types, files extensions etc. I use both professionally on different projects and Prisma always feels like unnecessary auto magic.

I just added prisma v7 to our (alpha) benchmarks earlier today, and it's often slower than v6: https://github.com/joist-orm/joist-benchmarks You can run just prisma v6/v7 with `yarn benchmark --orm prisma prisma_v7`, or `yarn benchmark` to do the full suite. I can't paste images of my local results, but prisma v6 runs the benchmark in 985ms, prisma v7 1498ms. 🤷 Tbf it looks like the `bulkCreate 100` result drives the majority of the perf difference, and otherwise they are ~same/same.

Videos

Is Drizzle Really Better Than Prisma? - YouTube

Prisma vs Drizzle: Seed the Prisma Database - YouTube

October 15, 2024

Is This ORM Better Than Prisma? (Drizzle)

Prisma vs Drizzle: Run a Simple Find Query with Drizzle - YouTube

October 15, 2024

Prisma vs Drizzle: Using Prisma and Drizzle Studio - YouTube

October 15, 2024

reddit.com › r/node › prisma vs drizzle, what's the current state?

r/node on Reddit: Prisma vs Drizzle, what's the current state?

June 15, 2024 -

Planning to use one of these. Thoughts guys? Last thread I saw was 5 months ago. Things evolve quick.

Prisma is older. Looking back and being smarter now: Their technical concept (running a Rust service as the middleman) was the wrong decision. This physical and conceptual abstraction is not necessary and at the same time a burden. I'm still kind of perplexed that Prisma didn't do proper joins for years until forced by the competition. So, I don't have much trust in the Prisma engineering. Typesafe querybuilders like Drizzle or Keysely are much slimmer. They translate TS to SQL "on the fly" and send it directly to the DB. Imagine how much simpler this is than sending it to a Rust middleman that in turn does maybe good things, but probably complex things and sends it then to the DB. The way back goes through the middleman as well. Drizzle indeed sends one query to the DB, where Prisma didn't do this for years. That alone indicates how complex the concept is. I mean, it's so much easier to translate same TS syntax for a JOIN to an SQL JOIN and call it a day. The question is: Do you benefit from Prismas concept in any way? If not, go for one of the slimmer and simpler querybuilders. I admit, I don't know about the matureness of Drizzle. But there're other alternatives like Keysely. EDIT: Having all that said I forgot about the Pros of Prisma, which was not fair, so here we go: Prisma is probably the most mature out there. It is still very popular, so much more battle tested. Prismas schema definition and migrations are absolutely top-notch. The docs are best in class. They even explain basic concepts better than most of the dedicated resources for those. And Prisma will not go away. The company might get in trouble financially, but Prisma will stay, as it is already huge.

Both seem great. We use Prisma in prod and are happy with it -- it's a massive upgrade over TypeORM. Great typing and extensible. But if you want to trade some ergonomics for greater control over your queries, go Drizzle.

reddit.com › r/node › prisma or drizzle

r/node on Reddit: prisma or drizzle

March 30, 2026 -

I'm about to start a project at work—it'll be an Express API—and I'm trying to decide which ORM to use. I really like Drizzle, but I'm a bit concerned that it doesn't have many features for handling migrations, and I've noticed that Prisma has improved a lot. What do you think?

I use Prisma at work, I know it's not popular here but we've had no major issues with it.

i personally like prisma more than drizzel. i never had issue with running migrations in prisma but every single time in drizzle ( skill issue ) but for me prisma > drizzle

reddit.com › r/microsaas › drizzle vs prisma: which one to choose?

r/microsaas on Reddit: Drizzle vs Prisma: Which One to Choose?

November 18, 2025 - In the end, I went with Drizzle since I’m pretty comfortable with SQL and really like how lightweight it is.

reddit.com › r/webdev › drizzle, prisma or typeorm? it seems that prisma officially admits that typeorm is fastest.

r/webdev on Reddit: Drizzle, Prisma or TypeORM? It seems that Prisma officially admits that TypeORM is fastest.

November 22, 2024 -

So Prisma officially stated that it is slowest ORM in most things: Prisma | ORM Benchmarks (official testing done by Prisma). TypeORM seems to be fastest.

What are your experiences with these ORMs? Is there anyone who tried every one of them?

I would love to hear your opinions :)

I don't care about speed difference in milliseconds, if I did I wouldn't use an ORM. Having tried all of them, I prefer Drizzle! TypeORM was the worst for me, annoying developer experience overall

I’ve used Drizzle and Prisma, I like everything about Drizzle except the verbose way of describing relations.

reddit.com › r/nextjs › prisma or drizzle orm which one best?

r/nextjs on Reddit: PRISMA or DRIZZLE ORM which one best?

February 5, 2024 -

so guys i have used prisma in my last project its good as i used an orm first time but i saw Drizzle orm on their site they states that its 10x faster than prisma , and im thiking to that its not late yet to convert to drizzle , so can you guys suggest me which one is best ? prisma orm or drizzle orm ?

also can you suggest me an free database which is faster ? mongodb kind of slow

Try it and see for yourself. Personally I like Drizzle, but I had to use both of them to see which one made more sense. There isn't a universal answer. No one is going to be able to recommend one that is faster because we don't know what "faster" means to you. What's slow about Mongo? Reads? Writes? Honestly if you are having database perf issues on an app small enough to use a free tier of anything, it is more likely something in your code than something in the database. Could also be artificial throttling by the hosting provider.

Drizzle. Prisma is very bad when you want very complicated queries. Also - it's constant polling is very heavy on DB. Also - you can just install PG / Mysql lib and do it the best and fastest way --> SQL queries.

reddit.com › r/nextjs › which database orm do you prefer?

r/nextjs on Reddit: Which database ORM do you prefer?

October 19, 2025 -

I’m building my first project in Next.js .I’ll be using PostgreSQL as my database and I’m trying to decide which ORM or database library would be best to use? or Would it be better to skip ORM and just use pg with raw SQL for now?

Drizzle seems to be the future, but it is not yet in 1.0, which is a little turn off for me. Relations and join tables are much cleaner in Prisma. Setting type for JSON fields is cleaner in Drizzle. Comments that Prisma is slow are little out of date, because they fixed many things that were problematic in last couple of months or so. Also, it really does not make a difference if your query takes 1ms or 1.2ms to execute, so don't worry about it. So, yeah, I would recommend going with Prisma - It is more stable and battle tested.

Find elsewhere

Google Bing Mojeek

reddit.com › r/brdev › which orm to choose? typeorm, prisma or drizzle

r/brdev on Reddit: Which ORM to Choose? TypeORM, Prisma or Drizzle

April 10, 2025 -

Hey sub!

Here at the company we work in a Node ecosystem and almost all of our backend uses NestJS. We recently ran into some projects and I raised the possibility of working with ORMs instead of using raw queries. I pointed out some things, like error tracking, vulnerability prevention, better maintenance, and some other points.

In the end, everyone liked it, but we reached an impasse on which ORM to choose as our "go-to". I only have experience with TypeORM and the other devs (2) only with Prisma, so which one to choose? The one that guarantees functionality and stability but is community-maintained, or the one that's always updating (for better or worse lol) and beloved by the people, Prisma?

NOTE: While studying Prisma I ran into this Drizzle thing. Is it worth it? Would it be a good idea to give it a chance considering its recent popularity?

I've used Prisma and Drizzle, so I'm qualified to talk about both. Drizzle is lighter, has better DX, and better-written documentation. Even though Prisma is more battle-tested, I think Drizzle still wins.

Did you try Sequelize?

reddit.com › r/nextjs › best db orm for production

r/nextjs on Reddit: Best DB ORM for production

April 28, 2025 -

I have been using Prisma, and im satisfied with it even though i had a few rough understanding especially when started. However i have been hearing about other alternatives like Drizzle, and contemplating wether it's worth my time to change after heavy use with Prisma ORM

I look back now at the weeks / months I wasted when I first started building an app on trying to find the most optimal stack and wonder what the hell I was doing Postgres vs MySQL vs SQlite vs Mongo Prisma vs Drizzle Supabase instead of any of these? Learning to use AWS services like SES and S3 vs using wrappers like Resend and UploadThing ShadcnUi vs DaisyUi vs NextUi vs Rawdoging the Ui AuthJS vs Clerk vs Kinde vs Supabase auth vs BetterAuth Hosting on Vercel vs Cloudflare vs VPS / Coolify Just pick something and learn to use it - if you hate using it, then pick something else. But once you find something you’re satisfied with (like Prisma in your case) leave it alone. Spending hours / days learning something and refactoring your code for a tiny marginal gain is just procrastination

Comparison is the thief of joy. If prisma is working for you, keep it. If you’re looking to just hobby. Try it. The competition is all approaching marginal gains.

reddit.com › r/node › prisma vs drizzle orm for production?

r/node on Reddit: Prisma vs drizzle ORM for production?

June 29, 2023 - If you're seeking some ORM caps, then Drizzle is the only choice between the two, else really comes down to personal pref imo. ... I think it failed with heavy join/subquery use. But is has been a very long time.

reddit.com › r/node › prisma vs. drizzle: which one should i use?

r/node on Reddit: Prisma vs. Drizzle: Which One Should I Use?

July 13, 2024 -

I'm working on a Node.js project with PostgreSQL and I'm trying to decide between Prisma and Drizzle. Which one do you recommend and why? Looking for insights on ease of use, performance, TypeScript support, and community. Thanks!

The technology doesn't matter. SOLVE THE PROBLEM!

Use your cognition to think about what matters the most THE PROBLEM / THE GOAL

Prisma, then if you find that it's too slow, or you miss writing queries yourself, Drizzle

reddit.com › r/node › am i bad guy for using prisma and drizzle at the same time in one project ?

r/node on Reddit: Am I bad guy for using Prisma and Drizzle at the same time in one project ?

December 13, 2024 - For example simple queries like SELECT * ... ORDERY BY random() is not possible in prisma, in this case I used to write sql using typedsql, but that not that convenient. it kinda ok for complex queries but... creating file for single simple line of sql... ? and go to definitionnot work with it... I was suffering with that, until... I found about Drizzle, it lacks some futures from prisma - synthetic relation tables(for many to many), automatic joins - I know it costs more CPU time even with relationJoins previewFeatures enabled, but just for trying something - that's great

reddit.com › r/node › wich orm to choose from drizzle orm or prisma

r/node on Reddit: Wich ORM to choose from Drizzle ORM or Prisma

November 14, 2023 -

Hello I am building an ecommerce app with nextjs. Now I am not sure wich ORM I should use. I installed Prisma with my data on Planetscale. Then I tried Drizzle with Neon. Here is the plus option I can use Postgresql with better constraints and enums. What would you use for production and best performance possible in combination with trpc

drizzle is newer and has better performance. prisma has some issues but they are fixing them (e.g. NOT using joins in queries). i'd go with drizzle. You might want to look into "Kysely". It's not an ORM but a very good query builder with "type safety" and autocomplete.

I found Drizzle has a really good developer experience. You are essentially building SQL like expressions and it has really nice Typescript support. Wouldn’t use anything else these days.

reddit.com › r/nextjs › what orm do you use?

r/nextjs on Reddit: What ORM do you use?

September 2, 2024 -

I really appreciate the developer experience with Prisma, but I often hear concerns about its performance. This makes me consider switching to another ORM like Drizzle. However, I'm concerned about Drizzle's relative newness in the market and want to ensure it’s reliable for production use.

even if drizzle might be better i use prima for his syntax

I really wish there was something with the software quality of drizzle but the query syntax of prisma.

reddit.com › r/node › what is the go-to orm by now?

r/node on Reddit: What is the Go-To ORM by now?

April 11, 2025 -

So, it's been 10 months since the last post on Drizzle vs Prisma. What are your thoughts now? Is Prisma the "Go-To" ORM for Node.JS ecossystem or there's a better one?

Don't cargo cult. Read, compare, write PoCs. Pick what fits your use case, your workflow, and team's proficiency with TypeScript, SQL, etc.

No ORM just Kysely for my work. Does everything we need. If you need an ORM though definitely Drizzle.

buildmvpfast.com › home › blog › prisma vs drizzle for a startup: which orm should you bet on in 2026?

Prisma vs Drizzle ORM for Startups 2026 | Which to Pick

April 23, 2026 - Prisma Migrate needs a shadow database for development (an extra DB running alongside yours to diff schemas). Drizzle Kit generates timestamped SQL files with drizzle-kit generate or lets you push directly with drizzle-kit push during prototyping. That said, several Reddit users flagged Drizzle’s migration system as fragile: “It constantly tries to rerun migrations that have already ran and then fails.” Neither tool handles rollbacks gracefully.

reddit.com › r/node › why is drizzle so popular over keysly in 2025?

r/node on Reddit: Why is Drizzle so popular over keysly in 2025?

May 26, 2025 -

I’m honestly confused about Drizzle’s popularity right now. I was using it for a project, messed up a migration, and realised there’s no way to roll it back. If you make a mistake, you’re stuck and must fix things manually or start over. That’s a huge risk for production work.

On top of that, Drizzle was converting my serial column into the serial datatype, which wasn’t what I expected and could cause more problems.

The syntax also feels weird and full of function calls, and writing nested queries or subqueries is way more complicated than it should be.

Meanwhile, Kysely has a really good migration system, auto-generates types, and the queries are much more readable and intuitive. Am I missing something? Why is Drizzle getting so much hype when it doesn’t feel production-ready? I would love to hear real experiences.

I have no real opinion on Node ORMs as I’m not really in that world these days. But I will say that rolling back DB migrations has always been a bit controversial. There are a lot of migrations that just can’t be rolled back in a simple way. So the idea of creating a rollback step that can automatically fix things all the time is a bit of a pipe dream. If you don’t have a process to intervene on your production database if necessary you should not be the one defining database migrations

I am surprised that no one is talking about sequelize. The issue I have with all those new ORMs, it’s that they are not feature complete. We are using Prisma in production and lack: Pessimistic locking, builtin soft deletes mechanism, partial indexes, … Also we have few issues opened related to those topics and things get hardly covered. I don’t get the reason why the JS/TS community is always trying to create new ORM, why not focusing on a solid one? The worst is that projects get created and then die few years after. To be honest I rarely seen so many dead projects in an ecosystem. I sometimes feel really frustrated by the community and the visions within it.

reddit.com › r/node › from knex to drizzle or prisma? looking for feedback

r/node on Reddit: From Knex to Drizzle or Prisma? Looking for feedback

May 7, 2026 -

Hey everyone,

I’m starting a new Node.js/TypeScript/PostgreSQL project and I want to move away from Knex and test something new for this one.

I’m pretty comfortable with SQL and after doing some research, the two options that stand out the most are Drizzle and Prisma.

For people who have used one (or both):

What made you choose it?

Any regrets or pain points?

How good is the migration workflow?

If you came from Knex, which one felt more natural?

I’d love to hear feedback before committing to one for a new project.

Thanks

drizzle. Nothing else comes close

they all try to solve similar problems, but might have different approaches for smaller things. i suggest you try these on your own before deciding which route to take: - transactions per http request - complex relationship of many to many - pivot data - guards aka scope aka … where you can apply extra conditions to all models based on what user is authorized to see - caching - logging of about to be executed queries these tend to be stuff i focus on when testing a new orm library.