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?

Discussions

What are the benefits of using Prisma over Mongoose? How do you decide which ORM to use in your projects?
What kind of factors should I consider, ... cons of Prisma and Mongoose? I'd like to be able to make this decision intelligently, not based on what's easy and familiar vs what's cool. (I know that there are other ORMs aside from these two, but these two seem to be more popular from what I see. I figured it's not worth confusing myself even more with more alternatives, since I don't ... More on github.com
🌐 github.com
3
27
Alternative to Prisma for Postgresql

I think knex + sql-ts make a solid base for typescript projects without compromising in functionality. Knex also has support for db migration, using a different approach than prisma.

If your are building a graphql api, add apollo-server + graphql-codegen for maximum typescript integration. There is no need for any ORM-like solution in this case.

If you are developing a REST API, add Objection ORM.

More on reddit.com
🌐 r/node
4
2
July 27, 2020
Is Prisma a viable alternative for TypeORM?
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. More on reddit.com
🌐 r/node
76
78
January 24, 2021
Drizzle ORM-typesafe alternative to knex/prisma
Great job and impressive results! As I can see, it is a query builder with cool TS support, so it is a replacement for Kysely. But not a replacement for ORM or Prisma, because they also help with relations. So in your examples for querying related tables, you're doing this with joins as a query builder would do, and if we check how the same is done by ORMs there will be the simplified syntax that hides join or multiple queries behind. More on reddit.com
🌐 r/node
9
25
January 19, 2023
People also ask

Why is Prisma so popular?
Prisma gained popularity through excellent developer experience: intuitive schema language, Prisma Studio for visual data browsing, comprehensive documentation, and strong TypeScript integration. It lowered the barrier for developers who aren't SQL experts while maintaining type safety.
🌐
makerkit.dev
makerkit.dev › blog › tutorials › drizzle-vs-prisma
Drizzle vs Prisma ORM in 2026: A Practical Comparison for TypeScript ...
What are the disadvantages of Prisma?
Prisma's main drawbacks include: the required 'prisma generate' step after schema changes, less SQL control for complex queries, and historically tricky edge runtime support (improved in v7). For most applications, these are minor trade-offs.
🌐
makerkit.dev
makerkit.dev › blog › tutorials › drizzle-vs-prisma
Drizzle vs Prisma ORM in 2026: A Practical Comparison for TypeScript ...
Is Drizzle really better than Prisma?
Neither is objectively better. Drizzle excels in bundle size and SQL control. Prisma excels in developer experience, tooling (Prisma Studio), and documentation. Choose based on your deployment environment and team's SQL comfort level.
🌐
makerkit.dev
makerkit.dev › blog › tutorials › drizzle-vs-prisma
Drizzle vs Prisma ORM in 2026: A Practical Comparison for TypeScript ...
🌐
ZenStack
zenstack.dev › blog › prisma-alternative
ZenStack V3: The Perfect Prisma ORM Alternative | ZenStack
November 30, 2025 - As a new challenger in this space, ZenStack aspires to be the spiritual successor to Prisma, but with a light-weighted architecture, a richer feature set, well-thought-out extensibility, and an easy-to-contribute codebase.
🌐
MakerKit
makerkit.dev › blog › tutorials › drizzle-vs-prisma
Drizzle vs Prisma ORM in 2026: A Practical Comparison for TypeScript Developers
January 24, 2026 - Both provide type-safe database access, but they take fundamentally different approaches: Prisma abstracts SQL behind a schema-first design, while Drizzle keeps you close to SQL with a code-first TypeScript API.
🌐
Strapi
strapi.io › blog › orms-for-developers
Top 5 ORMs for Developers in 2026
June 14, 2026 - Different ORMs express this mapping differently. Schema-first tools like Prisma use a dedicated schema file to generate both database migrations and a type-safe client. Code-first ORMs like TypeORM and MikroORM rely on decorator annotations on entity classes.
Find elsewhere
🌐
Prisma
prisma.io › home › typeorm › typeorm › typeorm › typeorm
Prisma ORM vs TypeORM | Prisma Documentation
TypeORM and Prisma ORM operate on different levels of abstraction. TypeORM is closer to mirroring SQL in its API while Prisma Client provides a higher-level abstraction that was carefully designed with the common tasks of application developers in mind.
🌐
Product Hunt
producthunt.com › products › prisma › alternatives
Prisma Competitors & Alternatives (2026) | Product Hunt
1 week ago - Explore Prisma alternatives: discover Neon, Supabase, PlanetScale, Turso, and Convex for serverless databases, realtime backends, and more.
Rating: 5 ​ - ​ 38 votes
🌐
ZenStack
zenstack.dev › blog › orm-2026
Prisma vs Drizzle vs ZenStack: Choosing a TypeScript ORM in 2026 | ZenStack
April 2, 2026 - The main concern is strategic: Prisma the company has increasingly shifted focus toward its hosted products (Prisma Postgres, Prisma Accelerate), and ORM innovation has slowed as a result. Drizzle has grown remarkably fast for a newer tool — evolving from a lightweight alternative into a serious contender, production adoption at scale, and performance numbers that matter for serverless and edge deployments.
🌐
Medium
medium.com › @shariq.ahmed525 › popular-orms-and-their-difference-prisma-typeorm-and-sequelize-564a83575eea
Popular ORMs and Their Difference: Prisma, TypeORM, and Sequelize | by Shariq Ahmed | Medium
January 18, 2024 - Sure, you can use SQL for this, but why use SQL when there are ORMs available to simplify the entire process? Today, I’ll cover three ORMs: TypeORM, Prisma, and Sequelize.
🌐
Encore
encore.dev › articles › drizzle-vs-prisma
Drizzle vs Prisma in 2026 - Which TypeScript ORM Should You Choose – Encore
April 17, 2026 - Drizzle and Prisma are the two most popular TypeScript ORMs, and they take fundamentally different approaches. Prisma uses a schema-first model with a custom .prisma DSL and generated client. Drizzle uses a TypeScript-native schema with SQL-like query syntax.
🌐
Hacker News
news.ycombinator.com › item
All these things fall short the moment you need real "production" features, such... | Hacker News
September 16, 2020 - So far, the best thing I've found in the node ecosystem is Prisma [1], and it's better than the alternatives by a very long shot in my opinion · Or are we talking of just writing a "CREATE TABLE..." and hand it over the wall to the ops? I agree that's simpler. Not something I like to do these days
🌐
G2
g2.com › home › application development software › application development platforms › prisma › prisma alternatives
Top 10 Prisma Alternatives & Competitors in 2026 | G2
The best Prisma alternatives are Snowflake, Microsoft SQL Server, and SAP HANA Cloud. Find top-ranking free & paid apps similar to Prisma for your Application Development Platforms needs. Read the latest reviews, pricing details, and features.
Top answer
1 of 1
39

Hey Mike, thanks for the great question! Speaking as someone who's working on MongoDB for Prisma, I'll try to leave my bias at the door.

My personal suggestion would be to use what you know. If you're comfortable working with Mongoose, then go with that. It was the first major ORM to be written in Node, so it's had many years to add useful features and squash bugs.

What you may find down the road with Mongoose is that it's easy to lose track of the structure of your database. As you add features and fix bugs, the structure of your data will change. This is best illustrated with an example:

Maybe your application has zip codes and for the longest time it was just a number, but now you realize that it should actually be a string. If you simply adjust the type from a number to a string in Mongoose and start writing strings to zipCode, Mongoose will merrily do that for you. Without consciously migrating your existing data, your database will have zip codes with both numbers and strings. This may introduce bugs in your application because Mongoose will lead you to believe that zip codes are all strings. This may seem like a simple fix, but these changes compound over the lifetime of an application.

Prisma enforces a schema on top of MongoDB. You can find an example schema in our documentation. With a schema, you always know the structure of your database.

We enforce a schema because we believe that:

  • Understanding the structure of your data is essential to maintaining a project over a long period of time. This is especially important if you plan to onboard new developers.
  • Changing the structure of your data (e.g. number to string) is always an important event. It shouldn't appear to work when it doesn't. We can provide tools like Prisma Migrate to streamline such events.
  • By knowing the schema, you can build sophisticated tools to provide a better developer experience that are tailored to your application. Tools like our type-safe Prisma Client and Prisma Studio.

MongoDB support in Prisma is still in it's early days, we don't yet have a Migration tool or Studio support. What we do have is a type-safe, auto-generated database client called the Prisma Client. You can get a better sense of what the Prisma Client supports in our documentation. It's not a 1:1 mapping with Mongoose, but we support most of the things you need to do in Mongoose in a more type-safe way.

We'll also make it easy to switch from Mongoose to Prisma once we introduce Introspection Support for MongoDB. So you have time to make your decision.

Hope this helps!

🌐
DEV Community
dev.to › zenstack › what-prisma-doesnt-have-yet-pan
What Prisma doesn’t have yet - DEV Community
June 27, 2025 - First of all, this is not a post trying to blame Prisma and promote some other alternatives. Instead,... Tagged with prisma, webdev, javascript.
🌐
Prisma
prisma.io › home › mongoose › mongoose › mongoose › mongoose
Prisma ORM vs Mongoose | Prisma Documentation
Learn how Prisma ORM compares to Mongoose · This page compares the Prisma ORM and Mongoose APIs. If you want to learn how to migrate from Mongoose to Prisma, check out this guide
🌐
PhotoPrism
photoprism.app
Browse Your Life in Pictures – PhotoPrism
AI-powered, privacy-first, self-hosted app for browsing, organizing, and sharing photos and videos
🌐
PRISMA statement
prisma-statement.org › extensions
PRISMA extensions — PRISMA statement
There are some other reporting guidelines that are closely aligned with PRISMA, which authors should find helpful. They include: SWiM, which provides reporting guidance for systematic reviews of interventions in which alternative synthesis methods to meta-analysis of effect estimates are used
🌐
Gartner
gartner.com › home › prisma › alternatives
Top Prisma Alternatives & Competitors 2026 | Gartner Peer Insights
Considering alternatives to Prisma? See what this market Prisma users also considered in their purchasing decision.
🌐
Libhunt
nodejs.libhunt.com › prisma-alternatives
Prisma Alternatives - Node.js Database | LibHunt
June 24, 2026 - Prisma replaces traditional ORMs and simplifies database workflows: Access: Type-safe database access with the auto-generated Prisma client (in JavaScript, TypeScript, Go) Migrate: Declarative data modelling and migrations (optional) Manage: Visual data management with Prisma Admin It is used to build GraphQL, REST, gRPC APIs and a lot more. Prisma currently supports MySQL, PostgreSQL, MongoDB. ... Based on the "Database" category. Alternatively, view Prisma alternatives based on common mentions on social networks and blogs.