Node.js ORMs overview and comparison

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
  • SonarQube - Static code analysis for 29 languages.
  • Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

    Prisma has a lot of open issues on GitHub: Also true, however I'm not sure if this is the right metric to evaluate Prisma's maturity. We're using GitHub as the main way to track engineering tasks and product ideas, so the number of issues doesn't necessarily represent "problems" (even less so "critical bugs"). This also means that there are lots of "internal issues" that are not urgent in any way but rather flesh out ideas where we'd like to get feedback from the community. I also don't think the number of issues indicates a lack of maintenance — on the contrary actually, I'd rather recommend to look at the release notes to get an understanding how many issues are closed with each release to get an understanding about how active the development on the Prisma ORM actually is! Does this mitigate your concern about high number of open GitHub issues? If no, I'd be very curious to hear what exactly you find problematic about this :)

  • cal.com

    Scheduling infrastructure for absolutely everyone.

    I'm really curious what makes you think that Prisma isn't ready for large projects? We've seen lots of companies building successful businesses (from small startups to enterprises) on top of Prisma already. We're listing a bunch of them on our Showcase page and you can also check out a number of real-world open-source apps that are built on Prisma, e.g. Cal.com (Calendly alternative with ~12k GitHub stars and >20k active users) or umami (Google Analytics alternative with ~12k GitHub stars).

  • 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!

  • redwood

    The App Framework for Startups

    Plus, Prisma is being adopted as the default ORM in popular frameworks like RedwoodJS, Blitz and other successful dev tools like Amplication and Keystone, so I'm wondering where this feeling comes from?

  • Umami

    Umami is a simple, fast, privacy-focused alternative to Google Analytics.

    I'm really curious what makes you think that Prisma isn't ready for large projects? We've seen lots of companies building successful businesses (from small startups to enterprises) on top of Prisma already. We're listing a bunch of them on our Showcase page and you can also check out a number of real-world open-source apps that are built on Prisma, e.g. Cal.com (Calendly alternative with ~12k GitHub stars and >20k active users) or umami (Google Analytics alternative with ~12k GitHub stars).

  • KeystoneJS

    The most powerful headless CMS for Node.js — built with GraphQL and React

    Plus, Prisma is being adopted as the default ORM in popular frameworks like RedwoodJS, Blitz and other successful dev tools like Amplication and Keystone, so I'm wondering where this feeling comes from?

  • amplication

    Amplication is an open‑source development tool. It helps you develop quality Node.js applications without spending time on repetitive coding tasks.

    Plus, Prisma is being adopted as the default ORM in popular frameworks like RedwoodJS, Blitz and other successful dev tools like Amplication and Keystone, so I'm wondering where this feeling comes from?

  • orms-overview

    Real world app with all known node orms

    Here is the post, u/BehindTheMath said "Raw SQL could be a viable option is there wasn't any JS logic and all the code was Knex." and I completely agree, and I can't even imagine how would you rewrite this knex code to raw sql.

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • dataloader-sequelize

    Batching and simplification of Sequelize with facebook/dataloader

    You can avoid the n+1 problem in Sequelize by using dataloaders https://github.com/mickhansen/dataloader-sequelize

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