Need advice about which tool to choose?Ask the StackShare community!


+ 1

+ 1
Add tool

PostGraphile vs Prisma: What are the differences?

Developers describe PostGraphile as "Instant GraphQL API for your PostgreSQL database; use standalone or as a Node.js middleware; MIT-licensed OSS". Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database. On the other hand, Prisma is detailed as "Prisma makes working with databases easy". Prisma is a powerful database tool used for data access, migrations and visual data management. It replaces traditional ORMs and removes friction from complicated database workflows.

PostGraphile and Prisma belong to "Query Languages" category of the tech stack.

Some of the features offered by PostGraphile are:

  • instant GraphQL schema via reflection over PostgreSQL database API
  • compiles complex GraphQL queries into very few SQL statements resulting in high performance
  • built entirely from plugins - heavily customisable

On the other hand, Prisma provides the following key features:

  • Simplified & type-safe database access
  • Declarative migrations & data modeling
  • Powerful & visual data management

PostGraphile and Prisma are both open source tools. Prisma with 14.9K GitHub stars and 872 forks on GitHub appears to be more popular than PostGraphile with 7.49K GitHub stars and 364 GitHub forks.

Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of PostGraphile
Pros of Prisma
  • 10
    Postgres based authentication
  • 6
    Great developer support
  • 5
    Lightning fast
  • 5
    Database first with no braking changes
  • 4
    Simple to set up and scale
  • 4
    Bye bye Resolvers
  • 2
    Instant production ready GraphQL
  • 2
    Easy setup of relationships and permissions
  • 2
    9 Automatically generates your GraphQL schema
  • 2
    Back to database first
  • 1
    Works with new and existing databases
  • 11
    Type-safe database access
  • 10
    Open Source
  • 8
    Auto-generated query builder
  • 6
    Supports multible database systems
  • 6
    Increases confidence during development
  • 4
    Built specifically for Postgres and TypeScript
  • 4
    Productive application development
  • 2
    Supports multible RDBMSs
  • 1
    Robust migrations system

Sign up to add or upvote prosMake informed product decisions

Cons of PostGraphile
Cons of Prisma
    Be the first to leave a con
    • 1
      Doesn't support downward/back migrations

    Sign up to add or upvote consMake informed product decisions

    What is PostGraphile?

    Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database

    What is Prisma?

    Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.

    Need advice about which tool to choose?Ask the StackShare community!

    Jobs that mention PostGraphile and Prisma as a desired skillset
    What companies use PostGraphile?
    What companies use Prisma?
    See which teams inside your own company are using PostGraphile or Prisma.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with PostGraphile?
    What tools integrate with Prisma?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to PostGraphile and Prisma?
    An open source GraphQL engine that deploys instant, realtime GraphQL APIs on any Postgres database.
    GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012.
    PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
    It supports both Active Record and Data Mapper patterns, unlike all other JavaScript ORMs currently in existence, which means you can write high quality, loosely coupled, scalable, maintainable applications the most productive way.
    Build a universal GraphQL API on top of your existing REST APIs, so you can ship new application features fast without waiting on backend changes.
    See all alternatives