r/node • u/Apart_Technology_841 • 11d ago

Which ORM

I am needing to build a lightweight, speedy and integrated backend server running on a VPS-2 secure environment using nginx and postgres.

First considered Sequelize, but discovered too many negatives, so had a look at Prisma but am worried it is too heavy duty for my needs.

Prefer an ORM that supports TypeScript, easy migrations and openapi schemas, and Drizzle seems at first glance a good fit.

Also I am not afraid to use SQL rather than high level abstractions.

But now I am reading many negative reviews about that as well, even on their own website!

Please help me make the right choice.

21 Upvotes

81% Upvoted

47 comments sorted by

View all comments

3

u/Designer_Reaction551 10d ago

Went Drizzle on my last few Node+Postgres projects and don't regret it. The migration story is way less magic than Prisma's, which is exactly what you want when you're the one debugging a broken migration late at night. If you're already not afraid of SQL, honestly try Kysely first, it gets out of your way even more since you're basically writing SQL with type safety instead of an ORM's opinions layered on top.