PostGraphile

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.

Pros & Cons of PostGraphile

Pro | 2

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.

Freddie Freddie 7 months ago
Pro | 1

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?

Freddie Freddie 7 months ago
Pro | 1

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.

Freddie Freddie 7 months ago

Add a Pro or Con

Only members can post Pros & Cons

Creating your profile only takes a matter of seconds, or login with an existing account.

Discover the pros and cons of PostGraphile and what other people have found to be an advantage or disadvantage when using the software. Currently no opinions have been posted. Have you used, or are using PostGraphile, if so, how was your experience?
Sort by