PostGraphile
vs
Hasura
PostGraphile
Hasura
What is PostGraphile?
PostGraphile (previously known as PostGraphQL) is a free an open-source software project that lets you spin up GraphQL APIs on top of an existing PostgreSQL database, instantly. PostGraphile automatically detects tables, columns, indexes, relationships, views, types, functions and comments in your database. Based on that information it generates a GraphQL server and API which is automatically updated when changes are made to the database or its data.
How much does PostGraphile cost?
No pricing information available..
What platforms does PostGraphile support?
Top PostGraphile Pros & Cons
PostGraphile automatically generates a GraphQL API from your PostgreSQL database schema
I love the fact that PostGraphile automatically detects tables, columns, indexes, relationships, views, types, functions and comments from my PostgreSQL database schema and instantly creates a GraphQL server and GraphiQL interface. With PostGraphile I can focus on what's important, making my idea come to reality, instead of fiddling with tooling.
Database-Driven Development
Everything in PostGraphile revolves around your database schema. You write SQL, and PostGraphile automatically generates your GraphQL API. At first I was sceptical towards the model of database-driven development, but it has taught me how powerful our relational databases really are. As of late, the trend has been to move further and further away from database layer, with the introduction of ORMs, NoSQL, Serverless etc.. maybe these ideas are misguided?
Makes use of PostgreSQL's row-level security
PostGraphile is built around features native to PostgreSQL. One such feature is PostgreSQL's row-level security, which can be utilized to build application authentication, authorization and role-based access systems right into your database.
Top PostGraphile Alternatives
Prisma
Prisma is a free and open source modern database access layer for TypeScript and Node.js. The software aims to make database access easier with an auto-generated and type-safe query builder that's tailored to your database schema. Prisma is a new take on the traditional ORMs and SQL query builders found in many frameworks and development solutions today. By providing a single access layer that works across databases and technologies Prisma creates what they believe to be the feature of database access and management. Prisma ships with the Prisma Client, a tool that makes it easy to reason about your database queries, so that you can focus on your data and application rather than complex SQL queries or ORM models. With Prisma you can create your own GraphQL or REST API that can access different types of databases including PostgreSQL, MongoDB and MySQL.
PostgREST
PostgREST is a standalone web server and development tool that automatically turns your PostgreSQL database into a RESTful API.
Strapi
Strapi is a free and open source headless CMS developed with JavaScript for Node.js. The software makes it really simple to generate REST and GraphQL APIs. Simply create your database schema and relationships in the Strapi admin panel UI, and Strapi will auto-generate API endpoints to represent the data structures provided. Strapi comes packed with features you come to expect from normal CMS's such as authentication, authorization, content management and a media library. The software can be used for free and can be self-hosted on any server and platform. Extra enterpise functionallity is currently being developed, and will be sold at cost.
The software
Hasura
is removed from the Top PostGraphile Alternatives since you are comparing against it.
If you are looking for more software, applications or projects similar to
PostGraphile
we recommend you to check out our full list containing 8 PostGraphile Alternatives.
PostGraphile Gallery
What is Hasura?
Hasura is a software development tool that lets you build real-time GraphQL APIs for a PostgreSQL database. The software is free and open source, while enterprise features are provided at a cost. Hasura is perfect for building GraphQL powered microservices and 3factor applications.
How much does Hasura cost?
Hasura is provided as cloud service and an open-source self-hosted version.
Cloud
Free
$0 a month
Personal use and basic sites
-
1 GB data pass-through
-
60 requests/minute
Standard
$99 a month per project.
-
20 GB data pass-through*
-
Unlimited requests
-
High Availability
Enterprise
-
SSO
-
Dedicated VPC with VPC peering
-
Custom data pass through pricing
-
24*7*365 Prod/Dev support
Self-Hosted
Hasura CE
-
Powerful queries out of the box
-
Realtime with subscriptions
-
Dynamic access control
Hasura EE
-
Enterprise grade security
-
Single Sign On
-
24*7*365 dedicated support
-
Enhanced performance and reliability features over CE
What platforms does Hasura support?
Top Hasura Pros & Cons
Fully consistent auto-generated GraphQL schema
The GraphQL schema generated by Hasura is consistent across types, fields, queries, mutations, and parameters. That' a huge advantage when it comes to maintaining API consistency across larger teams and, or projects.
Top Hasura Alternatives
Prisma
Prisma is a free and open source modern database access layer for TypeScript and Node.js. The software aims to make database access easier with an auto-generated and type-safe query builder that's tailored to your database schema. Prisma is a new take on the traditional ORMs and SQL query builders found in many frameworks and development solutions today. By providing a single access layer that works across databases and technologies Prisma creates what they believe to be the feature of database access and management. Prisma ships with the Prisma Client, a tool that makes it easy to reason about your database queries, so that you can focus on your data and application rather than complex SQL queries or ORM models. With Prisma you can create your own GraphQL or REST API that can access different types of databases including PostgreSQL, MongoDB and MySQL.
Supabase
Supabase is a free and open-source self-hosted and SaaS provided alternative to Firebase. With Supabase you can add a realtime REST API to a PostgreSQL without writing a single line of code.
Firebase
Firebase is a Platform-as-a-Service (PaaS) for hosting and develop mobile and web applications. With Firebase developers can move quickly and integrate with third-party software with less friction. Firebase provides an API that can packe your application into a single SDK that works cross-platform for iOS, Android, JavaScript and C++. The Firebase platform is owned by Google and to-date over 1.5 million applications has been shipped on the platform.
The software
PostGraphile
is removed from the Top Hasura Alternatives since you are comparing against it.
If you are looking for more software, applications or projects similar to
Hasura
we recommend you to check out our full list containing 11 Hasura Alternatives.