PostgREST

PostgREST

PostgREST is a standalone web server and development tool that automatically turns your PostgreSQL database into a RESTful API.

Alternatives to PostgREST

PostGraphile
1

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.

Suggested by Freddie Freddie
TOP PROS
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
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
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
TOP CONS
Strapi
0

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.

Suggested by Ironclad Ironclad
TOP PROS
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 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 Millen
TOP CONS
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 Freddie
Supabase
0

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.

Suggested by Freddie Freddie
TOP PROS
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 Millen
Instant REST API for PostgreSQL databases

With Supabase you can have a REST API automatically generated for your PostgreSQL database in minutes.

Freddie Freddie
TOP CONS
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 FI5HDOG
Fauna
0

Fauna

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.

Suggested by Lisa Mendes Lisa Mendes
Firebase
0

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.

Suggested by Samantha Samantha

Do you know of more PostgREST Alternatives?

Similar Alternatives

Sort by

PostgREST Alternatives 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 (a month ago)