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

PostGraphile

Stacks83

Followers204

+ 1

Votes47

Prisma

Stacks657

Followers784

+ 1

Votes52

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
3
Back to database first
3
9 Automatically generates your GraphQL schema
3
Easy setup of relationships and permissions
3
Instant production ready GraphQL
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

2
Doesn't support downward/back migrations
1
Doesn't support JSONB
1
Do not support JSONB
1
Mutation of JSON is really confusing
1
Do not support JSONB
0
Jjj

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

Backend Engineer, Search Product

San Francisco, CA, US; , CA, US

View Job Details

Full Stack Sr Software Engineer

CBRE

United States of America Texas Richardson

View Job Details

+20

Software Engineer II, (Backend) Runtime

Postman

, India

View Job Details

See jobs for PostGraphile

See jobs for Prisma

What companies use PostGraphile?

What companies use Prisma?

See which teams inside your own company are using PostGraphile or Prisma.

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?

Hasura

An open source GraphQL engine that deploys instant, realtime GraphQL APIs on any Postgres database.

GraphQL

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

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.

TypeORM

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.

Apollo

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

PostGraphile vs Prisma

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

Pros of PostGraphile

Pros of Prisma

Sign up to add or upvote prosMake informed product decisions

Cons of PostGraphile

Cons of Prisma

Sign up to add or upvote consMake informed product decisions

What is PostGraphile?

What is Prisma?

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

What companies use PostGraphile?

What companies use Prisma?

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

Related Comparisons

Trending Comparisons

Top Comparisons