Alternatives to PostgREST
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.
Most people think this is a good alternative to PostgREST.
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
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
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
Auto-generated GraphQL API and schema with the help of the "Shadow CRUD"
Possibly the fastest way to create a basic GraphQL API. With the help of Strapi graphQL plugin you can have your GraphQL API up and running in a matter of minutes. Where all necessary types and resolvers are auto-generated by Strapi's Shadow CRUD system. Simply install the plugin, and you can start using your GraphQL API with GraphiQL interface at /graphql.Freddie
Quick and easy installation
I love the fact that Strapi is extremely easy to install. The Strapi CLI will guide you through the process of installing the headless CMS manually. A bunch of one-click-install's and containers are available for third-party platforms and hosting providers as well.Millen
Does not handle database migrations
Strapi is a fantastic open-source CMS and API creation tool for frontend developers. However, one of the biggest concerns I have with Strapi is that your application does not record nor manage database migrations after schema changes to your database. This is a crucial part of building a sound and future proof application, without a record of schema changes things can get hairy quickly. It's kinda like building an application without using Git to track code changes.Freddie
Can be self-hosted
The fact that Supabase is a free and open-source firebase alternative that can be self-hosted makes it an extremely interesting project.Millen
Instant REST API for PostgreSQL databases
With Supabase you can have a REST API automatically generated for your PostgreSQL database in minutes.Freddie
Not ready for production yet
Supabase seems like a really cool project, but the project is still in alpha/beta stage and is not ready for production..FI5HDOG
Dashboard can not be self-hosted
A big part of Supabase is it's intuitive dashboard where you can edit your database, manage users, create object storage and run queries directly on the database. Sadly, this part can not be self-hosted, nor is it open source.fossa
Fauna is the data API for client-serverless applications. It provides web-native GraphQL interface, with support for custom business logic and integration with the serverless ecosystem. Fauna transforms the traditional DBMS into a Data API that gives you all of the capabilities of traditional database, without sacrificing flexibility, scale, and performance. By utilizing a globally-distributed storage and compute fabric, Fauna-powered applications are delivered to end-users fast and reliably on modern security infrastructure.
Do you know of more PostgREST Alternatives?
In this list you find PostgREST Alternatives for various platforms. All alternatives are generated by people like yourself. No AI, machine learning or randomness is used to list and rank the best alternatives for PostgREST.
List Last Updated:
26/01/2021 (4 months ago)