Prisma VS TypeORM

Compare Prisma vs TypeORM and see what are their differences.

Prisma

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview) (by prisma)

TypeORM

ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms. (by typeorm)
Our great sponsors
  • SonarQube - Static code analysis for 29 languages.
  • OPS - Build and Run Open Source Unikernels
  • Scout APM - Less time debugging, more time building
Prisma TypeORM
117 74
19,906 26,917
10.8% 2.0%
9.9 9.4
6 days ago 4 days ago
TypeScript TypeScript
Apache License 2.0 MIT License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

Prisma

Posts with mentions or reviews of Prisma. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-01-25.
  • Looking for a mentor(Full stack)
    3 projects | reddit.com/r/bangalore | 25 Jan 2022
    https://github.com/prisma/prisma (ORM)
  • New to PostgreSQL - Best way to use it?
    6 projects | reddit.com/r/PostgreSQL | 25 Jan 2022
    a) How will you do your queries from node. There's two, actually three approaches. First, writing SQL directly in your code (which I think is the one you should take), and in this case you would use node-postgres. The great thing about this is that you can try out some query in DBeaver or in psql (the command line) or some other tool and when it's right, just copy to your node.js code. Or conversely, if a query in your program isn't right, you can debug it in psql / DBeaver with some test inputs. Anyway another approach would be to use an ORM, and for this one I think the most popular in node land is Prisma (but I may be wrong). And then there's a middle ground which is like just writing queries, but instead of using sql syntax, you write it with JS methods and get them converted to SQL using a query builder. A nice query builder would be knexjs, and actually it's the kind of thing I would use myself (but I don't program in node). (Prisma itself has a comparison on those 3 approaches (actually, the whole Prisma documentation is pretty good))
  • Getting started with Adonis, Vue & Inertia
    6 projects | dev.to | 22 Jan 2022
    Lucid is AdonisJS Built-In ORM. It's extremely powerful and works much like Laravel's Eloquent ORM. While Lucid is built in, you can optionally use Sequelize or Prisma with AdonisJS as well.
  • Started 2022 by updating portfolio website
    3 projects | dev.to | 21 Jan 2022
    Linked with Prisma ORM
  • Debutur
    8 projects | dev.to | 13 Jan 2022
    Prisma
  • How to check if e-commerce site built from scratch is completely secure?
    1 project | reddit.com/r/webdev | 4 Jan 2022
    For a SQL database, PostreSQL has a learning curve to it, but it's one of the best SQL databases out there and definitely something you'll want to learn some day. Prisma has great support for it.
  • Recovering XAMPP developer looking to make a Node CRUD app. What Node database tools are easy to learn?
    8 projects | reddit.com/r/node | 30 Dec 2021
    I work at Prisma and we've built a new kind of ORM for Node.js. Prisma works differently compared to most traditional ORMs since it uses its own schema language to define application models which look like this:
  • What are your best Node tips/tricks/discoveries from 2021?
    8 projects | reddit.com/r/node | 28 Dec 2021
    Prisma... best ORM I've ever used. The TS support for end-to-end (DB+ORM>API>Frontend) typing of data is amazing.
  • Need feedback on APIs.
    2 projects | reddit.com/r/learnjavascript | 27 Dec 2021
    All questions for clarity aside, I will say that I’m currently working on my second ‘full stack’ project and I never finished my first one. What I’m using right now is Sveltekit with an SQLite database managed by Prisma for an ORM. I have to say it’s marvelous. Absolutely a dream, everything is coming together with very little effort (on the backend anyway, getting too picky with the UI).
  • How do most people interact with a db these days?
    5 projects | reddit.com/r/node | 27 Dec 2021
    Hey there, I work at Prisma and we're building a new and modern ORM that has been fully released for production this year.

TypeORM

Posts with mentions or reviews of TypeORM. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-01-27.
  • Which orm do you recommend when working with node
    1 project | reddit.com/r/node | 28 Jan 2022
    Most ORM comes with decoration or plug in to some decorations library. You can read here about typeorm decorators for example https://github.com/typeorm/typeorm/blob/master/docs/decorator-reference.md
  • Intro to GraphQL with Node.js & TypeScript
    2 projects | dev.to | 27 Jan 2022
    TypeORM is an amazing ORM, which we can use to interact with various databases. It also has really good TypeScript support and the way we define database entities in TypeORM will be very useful when we setup TypeGraphQL later in this post.
  • Setting up a basic TypeORM starter
    2 projects | dev.to | 16 Jan 2022
    TypeORM is a super popular system with a massive user base.
  • What ORM to use with TypeScript
    3 projects | reddit.com/r/node | 12 Jan 2022
    what are you talking about? https://github.com/typeorm/typeorm typeORM has 28k stars. Just had a new release in Nov. And has an active code frequency. What would you compare it to?
  • SeaOrm : any feedback ?
    3 projects | reddit.com/r/rust | 6 Jan 2022
    I've been bitten a few times by https://typeorm.io. The schema is declared in Entity class definitions. When the application connects to the database and the 'synchronize' option is enabled, the Entity definitions are compared to the DB schema and the DB schema columns are added/removed accordingly. This approach seems nice for development, but once an application hits production, it is easy to commit a change with synchronize=true, or to connect to a prod database with a development release. The risk is unexpected changes the schema, which could drop columns and cause chaos. IIRC, this is also a risk with SQLalchemy.
  • What are your best Node tips/tricks/discoveries from 2021?
    8 projects | reddit.com/r/node | 28 Dec 2021
    Yeah I've used TypeORM. I can't get over weird TypeORM APIs like this
  • It's Prisma Time - Introduction
    3 projects | dev.to | 13 Dec 2021
    Hi Folks 👋 and welcome back, Today I want to start a new series about Prisma. But before starting I want to explain the reason why of this series. In the last months I spent more time using ORM in the node eco-system. Most of the time I used typeorm. In my opinion Typeorm is a great ORM but creates entities and managing them sometimes it's not so easy, especially if you love to use typescript without classes. But one day in my twitter's wall appeared this tweet of @Matteo Collina that spoke about prisma, so I decided to spend some of my free time to understand better this tool. As you can imagine, it left me good impressions so I decide to share them with you using this series.
  • Where is Ruby Headed in 2021?
    14 projects | news.ycombinator.com | 18 Nov 2021
    TypeORM has a lot of issues but in our case it hasn't caused any major blockers. Most of the time the issue is with documentation and sometimes you run into issues like this: https://github.com/typeorm/typeorm/issues/316.

    NestJS on the other hand is very solid. It has good documentation and a good community. We haven't faced any issues with NestJS yet.

  • How can I use my Oracle Cloud wallet in TypeOrm.io?
    1 project | reddit.com/r/node | 16 Nov 2021
    OracleDB - problems with TNS options #3484
  • Why is TypeORM hated so much?
    2 projects | reddit.com/r/node | 16 Oct 2021
    Majority of the criticism I see is towards it being buggy and not maintained well. I haven't encountered any serious bugs, and the maintenance seems okay to me, according to Github change log and snyk analysis .

What are some alternatives?

When comparing Prisma and TypeORM you can also consider the following projects:

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

Mongoose - MongoDB object modeling designed to work in an asynchronous environment.

Knex - A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

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.

Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.

Bookshelf - A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

node-mssql - Microsoft SQL Server client for Node.js