What ORM would you recommend?

This page summarizes the projects mentioned and recommended in the original post on reddit.com/r/node

Our great sponsors
  • Appwrite - The Open Source Firebase alternative introduces iOS support
  • Scout APM - Less time debugging, more time building
  • SonarLint - Deliver Cleaner and Safer Code - Right in Your IDE of Choice!
  • koa-boilerplate

    A Fully Customized and Production Grade Koa REST API Implementing GoThinksters' RealWorld

    With typeorm I can't do even basic things without query builder, and it's query builder is very verbose. For example, (this is not my code, just example): https://github.com/eflem00/koa-boilerplate/blob/98265346877a30f3595baf6f574726078b2b6c54/src/controllers/ArticleController.ts - I have very similar code on current project, have to use query builder, define return types manually, awfully not readable

  • Sequelize

    An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js | Postgres, MySQL, MariaDB, SQLite, MSSQL, Snowflake & DB2

    Been using sequelize for a long time, but it just falls apart in certain scenarios. The github has tons of open and very real issues that have been open for years. It is nice and easy to use if you don't hit any of these scenarios though. Some of them I have personally experienced: https://github.com/sequelize/sequelize/issues/7649 https://github.com/sequelize/sequelize/issues/8457

  • Appwrite

    Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!

  • Objection.js

    An SQL-friendly ORM for Node.js

  • MikroORM

    TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts