Need advice about which tool to choose?Ask the StackShare community!
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
- Postgres based authentication10
- Great developer support6
- Lightning fast5
- Database first with no braking changes5
- Simple to set up and scale4
- Bye bye Resolvers4
- Back to database first3
- 9 Automatically generates your GraphQL schema3
- Easy setup of relationships and permissions3
- Instant production ready GraphQL3
- Works with new and existing databases1
Pros of Prisma
- Type-safe database access11
- Open Source10
- Auto-generated query builder8
- Supports multible database systems6
- Increases confidence during development6
- Built specifically for Postgres and TypeScript4
- Productive application development4
- Supports multible RDBMSs2
- Robust migrations system1
Sign up to add or upvote prosMake informed product decisions
Cons of PostGraphile
Cons of Prisma
- Doesn't support downward/back migrations2
- Doesn't support JSONB1
- Do not support JSONB1
- Mutation of JSON is really confusing1
- Do not support JSONB1
- Jjj0