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 authentication6
- Simple to set up and scale4
- Great developer support4
- Bye bye Resolvers4
- Lightning fast4
- Database first with no braking changes4
- Instant production ready GraphQL2
- Back to database first2
- 9 Automatically generates your GraphQL schema1
- Easy setup of relationships and permissions1
- Works with new and existing databases1
Pros of Prisma
- Open Source5
- Type-safe database access4
- Auto-generated query builder4
- Built specifically for Postgres and TypeScript3
- Supports multible database systems3
- Increases confidence during development3
- Productive application development3
- Supports multible RDBMSs0
Sign up to add or upvote prosMake informed product decisions
Cons of PostGraphile
Cons of Prisma
- Doesn't support downward/back migrations1