Decision: Which ORM should we use?

[goldbergyoni]

Like any other decision, we wish to have a discussion and always compare the various options here

Which Node.js ORM should use? What important dimension should be evaluated?

[rluvaton]

Let's take a step back and ask, do we even want an ORM? What about query builder?

If we do decide to go with ORM than my important dimensions IMO are:

1. Performance
2. Security to help protecting from SQL injections
3. Support for multiple DBs (optional not required)
4. Migration support
5. Type support (Maybe)

[aagamezl]

I like the ORM option more than a Query Builder and my vote goes to Prisma.

[koyuncuoglum95]

@goldbergyoni, I'd suggest you to use mongoose and Prisma.

Mongoose: 1.) provides a straightforward
2.) schema-based solution to model your application data 3.) along with built-in type casting 4.) validation, query building 5.) business logic hooks

Prisma: 1.) Strongly-Typed API 2.) Auto-Generated Client 3.) Declarative Schema Language 4.) Support for Complex Queries 5.) Database Migrations 6.) Rich Data Modeling 7.) Developer Experience 8.) Support for Multiple Databases