Prisma VS PostgreSQL

Compare Prisma vs PostgreSQL and see what are their differences.

Prisma

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview) (by prisma)
Our great sponsors
  • Scout APM - Less time debugging, more time building
  • SonarLint - Deliver Cleaner and Safer Code - Right in Your IDE of Choice!
  • OPS - Build and Run Open Source Unikernels
Prisma PostgreSQL
117 34
19,906 10,145
10.8% -
9.9 6.4
6 days ago 4 days ago
TypeScript JavaScript
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.

PostgreSQL

Posts with mentions or reviews of PostgreSQL. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-01-25.
  • 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))
  • Node.js with Postgresql Bad Practice
    2 projects | reddit.com/r/node | 6 Jan 2022
    Here is link number 1 - Previous text "pg"
    2 projects | reddit.com/r/node | 6 Jan 2022
    That Postgres package looks interesting though! I've been using pg and it's been nice, though the syntax for escaping or generating SQL (there is a separate package for that) doesn't look as nice as this.
  • Help an old desktop dev learn a new trick?
    2 projects | reddit.com/r/webdev | 5 Jan 2022
    This is exactly what I'm doing this week in bootcamp, I'm using node-postgres, if you're familiar at all with JavaScript then you can check it out here
  • Solution to weird error when trying to use pg with SvelteKit in Vercel
    1 project | reddit.com/r/sveltejs | 23 Dec 2021
    Just spent a couple hours debugging a weird error when trying to use node-postgres with SvelteKit in Vercel: Could not resolve "pg-native" (mark it as external to exclude it from the bundle, or surround it with try/catch to handle the failure at run-time)
  • What is a relational database?
    5 projects | dev.to | 11 Dec 2021
    Node-Postgres on GitHub
    5 projects | dev.to | 11 Dec 2021
    Using Node-Postgres, write a program that creates a table.
  • How do I connect Angular with Vanilla Node Js (i.e without express or any similar framework)
    2 projects | reddit.com/r/angular | 9 Dec 2021
  • Tutorials for NodeJS + Postgresql
    1 project | reddit.com/r/node | 29 Nov 2021
  • What is this JavaScript "require"?
    1 project | reddit.com/r/codehunter | 26 Nov 2021
    I'm trying to get JavaScript to read/write to a PostgreSQL database. I found this project on GitHub. I was able to get the following sample code to run in Node.

What are some alternatives?

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

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

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

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.

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

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.

Objection.js - An SQL-friendly ORM for Node.js

lucid - AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more

sveltekit-prisma - A sample repository to show how SvelteKit and Prisma work together.

MongoDB - The Official MongoDB Node.js Driver

Passport - Simple, unobtrusive authentication for Node.js.

DataStax Node.js Driver for Apache Cassandra - DataStax Node.js Driver for Apache Cassandra

express-graphql - Create a GraphQL HTTP server with Express.