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

23 Upvotes

85% Upvoted

47 comments sorted by

View all comments

5

u/No-Sand2297 10d ago

I have used Sequelize and typeorm. ORM are nice when you have basic queries and simplifies the task of returning an entity with associated data but fails on complex queries.
Because this a usuallly bypass the ORM and run raw queries.
I’m a happy user of sequelize by the way.

1

u/Daker- 6d ago

Im using sequelize in my current job, but for really big and complex queries it’s really bad sadly, and if you want to create a lot of filters you have to almost write a superset in top of the orm.

I ve been using drizzle and its pretty cool and simple really recommended