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

PostGraphile

Stacks66

Followers147

+ 1

Votes33

Prisma

Stacks268

Followers434

+ 1

Votes25

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.

Pros of PostGraphile

Pros of Prisma

6
Postgres based authentication
4
Simple to set up and scale
4
Great developer support
4
Bye bye Resolvers
4
Lightning fast
4
Database first with no braking changes
2
Instant production ready GraphQL
2
Back to database first
1
9 Automatically generates your GraphQL schema
1
Easy setup of relationships and permissions
1
Works with new and existing databases

5
Open Source
4
Type-safe database access
4
Auto-generated query builder
3
Built specifically for Postgres and TypeScript
3
Supports multible database systems
3
Increases confidence during development
3
Productive application development
0
Supports multible RDBMSs

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!

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

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

Interest over time

News about PostGraphile

More news

News about Prisma

Prisma Shifts Focus From Photo Editing App to API-Driven B2B Services

(www.programmableweb.com)

Aug 22, 2017

More news