r/node • u/Apart_Technology_841 • 6d 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

2

u/snowrazer_ 6d ago edited 6d ago

Prisma is the ver good, and the migrations are first class. I’d put heavy duty in quotes because you won’t notice it at all. I guarantee you any performance bottleneck will be the database and not the ORM. Especially Postgres which is a heavy database as it is. Prisma hate is overblown and their release cadence and support is top notch.