Hasura vs PostGraphile

Hasura is a hybrid API platform that generates data APIs over connected databases, so developers do not need to write handlers, schemas, or resolvers. Hasura Cloud plans provide instant GraphQL APIs, RESTified endpoints, and GraphQL subscriptions. Listed database sources include Postgres-compatible systems, Microsoft SQL Server, BigQuery, Amazon Athena, Snowflake, MySQL, Oracle, MariaDB, MongoDB, and ClickHouse. APIs can be extended with remote schemas, remote joins, Actions, and event or scheduled triggers. Authorization can use an authentication provider of the customer’s choice, with JWT controls through headers, cookies, or webhooks. Cloud hosting is available on AWS, Google Cloud Platform, and Microsoft Azure Cloud. The Community Edition can run from a Docker image, while Enterprise Edition supports on-premises deployment. Hasura Cloud also lists GitHub, observability integrations, query allow lists, access controls, and DDoS monitoring. Plans include a free tier and paid options.

PostGraphile creates GraphQL APIs backed primarily by PostgreSQL, for applications such as SaaS backends and internal business tools. Its core features include GraphQL queries and mutations, automatic CRUD mutations, filtering, ordering, plugins, and authentication using JWT or custom pgSettings. It also supports row-level security and role-based access control. PostGraphile V4 Core and Version 5 are open source under the MIT license. Version 5 is built on Grafast, a planning and execution engine intended to improve performance and maintainability. The project can be self-hosted, and its homepage offers an `npx pgl` command to start with a PostgreSQL connection string. PostGraphile Pro adds query-cost, pagination, and query-depth limits, as well as a facility for scaling through database read replicas. The Pro plugin is for V4 Core; Version 5 remains open source and under development. V4 Core costs nothing. Pro License Only costs $25 a month, with up to four production instances and 100 development instances; larger clusters require custom licensing.