GraphQL
vs
PostGraphile
GraphQL
PostGraphile
What is GraphQL?
A free and open-source data query and manipulation language for APIs, combined with a runtime for fulfilling queries with existing data. GraphQL makes it easy to understand and query your data and bridge the gap between frontend and backend web development. The project is openly developed by Facebook, and community around it.
How much does GraphQL cost?
No pricing information available..
What platforms does GraphQL support?
Top GraphQL Alternatives
OpenRPC
OpenRPC is a specification that defines a standard, programming language-agnostic interface description for JSON-RPC 2.0 APIs.
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.
PostgREST
PostgREST is a standalone web server and development tool that automatically turns your PostgreSQL database into a RESTful API.
The software
PostGraphile
is removed from the Top GraphQL Alternatives since you are comparing against it.
If you are looking for more software, applications or projects similar to
GraphQL
we recommend you to check out our full list containing 4 GraphQL Alternatives.
GraphQL Gallery
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
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.
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.
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
GraphQL
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.