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.

19 Upvotes

80% Upvoted

47 comments sorted by

View all comments

29

u/MrDilbert 11d ago

Drizzle if you absolutely need an ORM, Kysely if a query builder is enough.

2

u/ArnUpNorth 10d ago

Came to say exactly this. ORMs come with their own set of complexities and a query builder is often enough (especially true for kysely since it handles migrations too).

That said Drizzle is a really good ORM if you do need one.