Need advice about which tool to choose?Ask the StackShare community!
Hasura vs PostGraphile vs Prisma: What are the differences?
- Deployment Method: Hasura provides a hosted service for easy deployment, while PostGraphile and Prisma need to be self-hosted.
- Data Sources: Hasura supports multiple data sources like SQL databases, GraphQL APIs, and REST endpoints out of the box, whereas PostGraphile and Prisma primarily work with SQL databases.
- Real-time capabilities: Hasura has built-in support for real-time GraphQL subscriptions, while PostGraphile and Prisma require additional setup for real-time data updates.
- Permissions and Authorization: Hasura has a robust Role-Based Access Control (RBAC) system for configuring permissions at a granular level, whereas PostGraphile and Prisma require more manual configuration for access control.
- Automatic Schema Stitching: PostGraphile has automatic schema stitching capabilities that allow for combining multiple GraphQL schemas easily, which is not available in Hasura and Prisma.
- Community and Documentation: Prisma has a comprehensive and well-maintained documentation, while Hasura and PostGraphile may lack extensive community support and documentation.
In Summary, Hasura, PostGraphile, and Prisma have differences in deployment methods, data sources, real-time capabilities, permissions and authorization, automatic schema stitching, and community support and documentation.
Manage your open source components, licenses, and vulnerabilities
Learn MorePros of Hasura
Pros of PostGraphile
Pros of Prisma
Pros of Hasura
- Fast23
- Easy GraphQL subscriptions18
- Easy setup of relationships and permissions16
- Automatically generates your GraphQL schema15
- Minimal learning curve15
- No back-end code required13
- Works with new and existing databases13
- Instant production ready GraphQL12
- Great UX11
- Low usage of resources4
- Simple4
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 access12
- Open Source10
- Auto-generated query builder8
- Supports multible database systems6
- Increases confidence during development6
- Built specifically for Postgres and TypeScript4
- Productive application development4
- Robust migrations system2
- Supports multible RDBMSs2
- CRUD1
Sign up to add or upvote prosMake informed product decisions
Cons of Hasura
Cons of PostGraphile
Cons of Prisma
Cons of Hasura
- Cumbersome validations3
Cons of PostGraphile
Be the first to leave a con
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
Sign up to add or upvote consMake informed product decisions
- No public GitHub repository available -
What is Hasura?
An open source GraphQL engine that deploys instant, realtime GraphQL APIs on any Postgres database.
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 Hasura, PostGraphile, and Prisma as a desired skillset
What companies use Hasura?
What companies use PostGraphile?
What companies use Prisma?
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 Hasura?
What tools integrate with PostGraphile?
What tools integrate with Prisma?
What tools integrate with Hasura?
What tools integrate with Prisma?
Sign up to get full access to all the tool integrationsMake informed product decisions
What are some alternatives to Hasura, PostGraphile, and Prisma?
Firebase
Firebase is a cloud service designed to power real-time, collaborative applications. Simply add the Firebase library to your application to gain access to a shared data structure; any changes you make to that data are automatically synchronized with the Firebase cloud and with other clients within milliseconds.
Heroku
Heroku is a cloud application platform – a new way of building and deploying web apps. Heroku lets app developers spend 100% of their time on their application code, not managing servers, deployment, ongoing operations, or scaling.
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.
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.
Strapi
Strapi is100% JavaScript, extensible, and fully customizable.
It enables developers to build projects faster by providing a customizable API out of the box and giving them the freedom to use the their favorite tools.