I was always for ORM's and have been moving away to just using a query builder instead like Kysely. Not an ORM, but also saves you from writing raw SQL . Answer from Deleted User on reddit.com
🌐
Reddit
reddit.com › r/node › prisma, typeorm, or something else?
r/node on Reddit: Prisma, TypeORM, or something else?
March 16, 2024 -

So, I'm starting a simple Express project, but we intend to eventually grow it, monetize it, and support it for a long time. But this project will also work as a portfolio project.

Should I use Prisma, TypeORM or something else? My guess is that since it's a simple project, it shouldn't matter that much, queries shouldn't be that complex for now at least, so I'd say the main question is, what ORM would improve my cv the most?

Preferred SQL ORM Oct 16, 2021
r/node
4y ago
Which ORM should I use? Aug 18, 2020
r/typescript
5y ago
More results from reddit.com
🌐
Reddit
reddit.com › r/webdev › which orm should i choose — prisma or typeorm?
r/webdev on Reddit: Which ORM should I choose — Prisma or TypeORM?
August 18, 2025 -

I’m building a backend with NestJS + Fastify + Supabase PostgreSQL and I’m trying to decide between Prisma and TypeORM as my ORM.

My main concerns are:

  • Future-proofing (I don’t want to regret the choice later)

  • Performance (good performance that won’t block me as the app grows)

The app is a hybrid of e-commerce + social media, with features like:

  • Auth: Sign up, Sign in

  • Social: Followers, Following, Posts, Likes, Trending

  • E-commerce: Sell, Buy, Orders, Cart, Wallet, Earnings

  • Messaging: Chat

  • Profile Features: My Posts, Library, Settings, Notifications, Requests

Which ORM would you recommend for this stack and why?

🌐
Reddit
reddit.com › r/node › which orm would you pick, prisma or typeorm
r/node on Reddit: Which ORM would you pick, Prisma or Typeorm
April 15, 2023 -

I know each has its strengths and drawbacks, I needed a type safe ORM that I can use with typescript and I ended up with these two. Has someone worked with both? What is the most featured in terms of queries, migrations, seeding, etc? Which provides better programming experience?

🌐
Reddit
reddit.com › r/node › new post: is prisma better than your 'traditional' orm?
r/node on Reddit: New post: Is Prisma better than your 'traditional' ORM?
December 6, 2022 -

Even if you live on Mars, you couldn't escape the big Prisma ORM hype

How is Prisma different than 'traditional' ORMs (TypeORM, Sequelize)? is it better? is it now the supreme choice for your next project ORM?

My new blog post covers these questions with code examples and numbers. It also includes a short hello-world section to give you a sense of how Prisma syntax looks like

Am I an ORM expert? Not at all. Although I have vast experience with databases, I'm writing from the perspective of a casual developer who seeks the right ORM for his next project. Hope you like it

https://practica.dev/blog/is-prisma-better-than-your-traditional-orm

Top answer
1 of 9
68
Sequelize core maintainer here! This is a great article. If you'll allow me, I wanted to give a few notes about Sequelize. Mostly about the upcoming Sequelize 7 :) Sequelize, for example, struggles to stabilize a TypeScript interface That was mainly due to Sequelize being written in JavaScript with type definitions written separately. Sequelize 7 is being rewritten in TypeScript and we've fixed so many typing issues! offers 3 different syntaxes + one external library (sequelize-typescript) that offers yet another style. I only know of two different syntaxes, so I may be misunderstanding you The good news is: sequelize-typescript is being ported into Sequelize as we speak, and its approach is going to be the recommended one starting with v7. The old approaches are not deprecated but are considered legacy. So the proper approach when using Sequelize is this one: class Order extends Model, InferCreationAttributes> { @Attribute(DataTypes.NUMBER) @PrimaryKey @AutoIncrement declare id: CreationOptional; @Attribute(DataTypes.NUMBER) @NotNull declare price: number; } You actually don't need to write OrderAttributes or OrderCreationAttributes. InferAttributes and InferCreationAttributes look weird, but it's not because we're trying to squeeze typescript in, but because we want users on v6 to be able to access the new simpler model definition without having to wait for the next major. In a future major release, models will be further simplified to this: class Order extends Model { @Attribute(DataTypes.NUMBER) @PrimaryKey @AutoIncrement declare id: CreationOptional; @Attribute(DataTypes.NUMBER) @NotNull declare price: number; } Wondering what CreationOptional is? It let's Sequelize know that "id" can be omitted when you call Order.create! :) As soon as TypeScript supports altering the type using decorators (which IIRC they're planning for the new decorators proposal), CreationOptional will become redundant and the model definition will be even further simplified Regarding querying: await getOrderModel().findAll({ // as you said, this is already strictly checked where: { noneExistingField: 'noneExistingValue' }, // I've fixed the last thing that prevented us from strictly checking this in v7. Expect this attribute to become strictly typed soon :) attributes: ['none-existing-field', 'another-imaginary-column'], // This one will also become strictly typed at some point, but we still have a few pre-requisites to complete first. Planned though! include: 'no-such-table', }); And for findByPk: await getCountryModel().findByPk('price') This is an interesting one. Thank you for getting it to my attention. Sequelize needs a way to know what the type of the PK is, and I think I could make that possible by introducing a new PK type like CreationOptional class Order extends Model { @Attribute(DataTypes.NUMBER) @PrimaryKey @AutoIncrement declare id: TPrimaryKey>; } // now sequelize knows that the PK of Order is of type number and can make this an error: await Order.findByPk('price'); Both also support other better patterns like the data mapper Unfortunately Sequelize does not support Data Mapper yet . That's something I'm actually working on right now as part of the migration of our codebase to TypeScript Sequelize documentation is mediocre That is objectively true :) I hope to be reassuring by saying that we know about it and we're also working on a full rewrite [about logging] This is better than nothing, but assuming you don't read production logs 24/7, you'd probably need more than logging While not perfect, did you know that you could set the "logging" option of the Sequelize constructor to a function? It gets called any time Sequelize needs to log something. I'm planning the design of the new API and I'll try to keep this issue in mind for it This is barely enough to cover a daily Starbucks cappuccino and croissant (6.95$ x 365) for 5 maintainers. Ahah yeah, I'm thankful I have a good job But at this point Sequelize is "too big to fail" imo. It's 13 years old (hence all the legacy ways of using Sequelize. It survived the many times we changed how we as a community write JavaScript) and while it has every now and then gone for a year without maintainers (I think that happened twice?), someone always eventually picked it back up (at least so far) (apologies for typos and awkward phrasing, I had to type this in a hurry :x)
2 of 9
13
Can the moderators enforce a rule against guerilla marketing and full disclosure of affiliations for post on the nodejs sub? Swear to god every second day there is some guerilla marketing prisma crap going on, or paid prisma shill posting as if they are normal people on reddit.
🌐
Reddit
reddit.com › r/node › an advise for a node.js orm other than prisma
r/node on Reddit: an advise for a Node.js ORM other than Prisma
July 28, 2022 -

I'm building the skeleton for a node.js enterprise-level application. And when it came to the ORM (with Postgres DB) I started with Prisma for all good features I read about it, especially after having hard time with Sequelize.

Unfortunately, my first issue I faced with Prisma is the lack of support for multi-files schema which broke the MVC pattern we adopting in our project.Then, I faced another issue which is lack of aws secret manager's support as Prisma only supports using .env files .

I need your recommendation of an enterprise-level ORM that is NOT SO COMPLICATED (which is against the whole point of using ORMs) and does support the above mentioned features.

Thanks.

🌐
Reddit
reddit.com › r/node › love prisma but feeling let down? this alternative is worth your attention.
r/node on Reddit: Love Prisma but feeling let down? This alternative is worth your attention.
November 30, 2025 -

I used to spend a lot of time working around some of Prisma ORM’s limitations by building complex wrappers on top of it. Eventually, I realized that creating a full alternative was the only way to address those issues cleanly.

That turned into ZenStack v3, which aims to be (almost) a drop-in replacement for Prisma. If you’ve felt limited or frustrated by Prisma lately, this might be relevant.

[DISCLAIMER: I'm the maintainer of the tool mentioned here]

What it provides:

  • Prisma-compatible schema and query API

  • Both a high-level ORM API and a low-level SQL query builder

  • Extra capabilities like fine-grained access control, polymorphic models, typed-JSON fields, etc.

  • A modular plugin system for extension and customization

Love to hear from others: What are the biggest gaps or pain points you’ve hit with Prisma?

🌐
Reddit
reddit.com › r/node › what's the best nodejs orm in 2026?
r/node on Reddit: What's the best nodejs ORM in 2026?
March 29, 2026 -

For a personal project I'm looking for a modern nodejs ORM or a query builder. I've done a lot of research and it's hard to know what's the best so I've done an excel spreadsheet :

ORMs Coded in typescript Query style
Prisma TRUE Schema + client API
Typeorm TRUE Decorators + Active Record/Data Mapper
Mikro-orm TRUE Data Mapper
Sequelize (half) Active Record
Query-builders
Drizzle TRUE Query builder + light ORM
Kysely TRUE Query builder
Knex _ Query builder
Objection _ Query builder + light ORM (Knex-based)

So far I have tested Drizzle and Prisma :

- Drizzle : I liked the simplicity and the fact that it's close to SQL. But I disliked a few things. Most of it is linked to the documentation and feedback from the CLI. First of all the maintainers don't even speak english properly so the documentation feels a bit low-cost. And most importantly, the Drizzle-kit CLI doesn't even give you any feedback when there is an error. It just stops without doing anything.

- Prisma : I tried it because ChatGPT told me it was the most popular and modern. I really liked the documentation and the CLI gives me good, verbose feedback when there is a problem. My only worry is that it's made by a company who seem really desperate for money because they are pushing a product that nobody cares about (Prisma Postgres).

What are your opinions? Should I stick to Prisma? (so far my best choice, but i'm open to alternatives).

🌐
Reddit
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

Find elsewhere
🌐
Reddit
reddit.com › r/node › is prisma a viable alternative for typeorm?
r/node on Reddit: Is Prisma a viable alternative for TypeORM?
January 24, 2021 -

We used TypeORM for some projects, but I don't like that we need to use classes and I'm also not a fan of annotations.

Prisma looks very attractive with its type safe client and the migrations that it offers.

Is it a viable replacement for TypeORM for projects that 2 to 3 people work on for 3-6 month? Anything we need to consider?

Top answer
1 of 20
56
It's worth knowing that Prisma v1 was completely dropped to maintenance mode about a year ago with very little prior warning. We use it for the majority of our GraphQL API, with very little resource to migrate to another framework completely, especially at the current size of our product. Prior to this, there was about 9+ months of complete radio silence on any GH issues (with a stalebot almost too eager to automatically close any issue not replied to for less than a week), a lot of which we were raising ourselves as well as writing our own contributions to bugfixes that were never approved or merged. My guess here is that they were working so flat out on the v2 product that they had very little if not completely no resource to support v1 which at the time was still under LTS. On top of that, a couple of weeks ago they moved the entire v1 project to a completely separate NPM package with a different name with almost zero warning too, causing hell for us for a couple of days, having to migrate our entire container provisioning infrastructure to point to the new package, before we could deploy to production again. I have never in my career experienced an open source codebase being migrated to a separate NPM project whilst still being actively downloaded 10k+ times a week. I've looked at Prisma v2, which I actually think looks pretty impressive and is definitely a vast improvement compared to v1, but I would like to include an element of risk to committing to using any of their products, as we have had to deal with the above for over 2 years. Just thought it would be worth mentioning some evident operational red flags with Prisma as a whole before you go ahead with investing time and effort migrating away from TypeORM.
2 of 20
23
I find it way better than type orm. No need to create models in code, just define the schema and the client is generated for you. Also, it’s way faster to learn. Because the schema is so easy to make, and the vs code plugin fixes and adds code when you save it. When using the client, vs code intellisense shows you how to do everything since it’s fully typed. There’s minimal api surface to learn to use it effectively compared to typeorm. Oh and the migration stuff is awesome. During early development I can push the schema constantly without ever making manual migrations.
🌐
Reddit
reddit.com › r/nestjs › nestjs orm (typeorm vs prisma)
r/nestjs on Reddit: NestJS ORM (TypeORM vs Prisma)
December 3, 2025 -

Hello, I'm a developer working with the nestjs framework.

I have a question and would like to get your opinions and help.

I know that TypeORM and Prisma are the two most popular ORMs used in nestjs. I've been spending several days debating which one is better.

I'd like to hear your opinions.

🌐
Reddit
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.

Top answer
1 of 29
42
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.
2 of 29
26
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.
🌐
BuildMVPFast
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 - 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. ... Not sure which stack to pick? We help founders choose the right tools and build with them. See how we work. ... Let me back up for a second. Performance benchmarks in the ORM space are a minefield. Prisma publishes benchmarks showing they’re faster.
🌐
Reddit
reddit.com › r/rust › is there an orm in rust with a dx similar to prisma orm ?
r/rust on Reddit: Is there an ORM in rust with a DX similar to Prisma ORM ?
February 3, 2025 -

I know this has been asked many times, but maybe there's a new ORM in town.

I'm looking for an ORM with the following features:

  • full typesafety

  • schema reflection from existing database

  • migration based on diff of current db vs last migration file state

  • autocomplete and type checking on relations

[Edit] I don't know why I am being down voted for asking this question ?

🌐
Reddit
reddit.com › r/node › is prisma better than mikroorm?
Is Prisma better than MikroORM? : r/node
March 20, 2025 - I currently use an sql builder but I've used both Prisma and MikroORM heavily in the past - and both are great at forming join performant joins. The people who will say "orm's are slow" or "prisma sucks" just echo whatever it is their favorite youtuber says, suck at modeling their schema, or they read an article well above their pay grade.
🌐
Reddit
reddit.com › r/nestjs › prisma vs mikroorm
r/nestjs on Reddit: Prisma vs MikroORM
July 6, 2025 - I'm having a hard time deciding which ORM to use in my NestJS app. I'm coming from Spring, where MikroORM's approach feels relatively similar to JPA — I load the entity, operate on it, and then persist changes by calling repository.save(entity). However, I see that Prisma is by far the most widely used and recommended ORM in the community, but its philosophy is quite different.