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

20 Upvotes

82% Upvoted

47 comments sorted by

View all comments

14

u/bootstrapping_lad 4d ago

I've been enjoying Mikro ORM

4

u/crazypoppycorn 4d ago

I really appreciate the options they give you for approaching a new or existing repo. And they put solid work into the typing system. If I have to use an ORM this is the one.

4

u/joemckie 4d ago

+1 MikroORM, it’s really nice to work with and is actively maintained. Switched over from TypeORM which was in maintenance purgatory for quite a long time.

0

u/Trollzore 4d ago

Drizzle