PostGraphile PostGraphile
vs
Supabase Supabase

This is a side by side comparison of PostGraphile and Supabase. Two products that are similar in nature, yet provide unique feature-sets that are worth taking in to account before making a purchasing decision or start using the software. This page can help you broadly analyze the products and weigh pros and cons against one another. Allowing you scrutinize peoples opinions about PostGraphile and Supabase, before making a decision if any of the products fit your use-case.

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?

PostGraphile is available for Windows , macOS , Linux , Web and Self-Hosted .

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.

Freddie
Freddie
4 years, 2 months ago
Pro

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
4 years, 2 months ago
Pro

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
4 years, 2 months ago
Pro

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.

Free , Commercial & Open Source , Proprietary
👍 Most people think Hasura is a good alternative to PostGraphile.

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.

Free , Commercial & Open Source
👍 Most people think Prisma is a good alternative to PostGraphile.

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.

Freemium & Open Source

The software Supabase Supabase 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 PostGraphile we recommend you to check out our full list containing 8 PostGraphile Alternatives.

PostGraphile Gallery

What is 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.

How much does Supabase cost?

Feature byPlans
 

Free

 

Pro

 

Pay as you go

 
Pricing

$0 /project /month

Perfect for hobby projects and experiments.

Get started

$25 /project /month

Everything you need to scale your project into production.

Get started

$25 /project /month plus usage costs

Designated support team, account manager and technical specialist.

Get started
 

Database

     
Dedicated Postgres Database Included in Included in Included in
Unlimited API requests Included in Included in Included in
Realtime functionality Included in Included in Included in
Optimized database instances Not included in Not included in Starting from $50/month
Database space Up to 500 MB Up to 8 GB $0.125 per GB
Automatic backups Not included in 7 days of backup 30 days Point in Time backup
Pausing Paused after 1 week inactivity Never Never
Transfer limits Up to 2GB Up to 50GB $0.09 per GB
 

Auth

     
Users 10,000 Users 100,000 Users Unlimited
Social OAuth providers Included in Included in Included in
Custom SMTP server Included in Included in Included in
Remove Supabase branding from emails Not included in Included in Included in
Enterprise OAuth providers Not included in Not included in Included in
Audit trails 1 hour 7 days Included in
 

Object storage

     
Storage total Up to 1 GB Up to 100 GB $0.021 per GB
Transfer limits Up to 2 GB Up to 200 GB $0.09 per GB
Custom access controls Included in Included in Included in

Dashboard

     
Team members Unlimited Unlimited Unlimited
Access controls Not included in Coming soon Included in
Audit trails Not included in Not included in Included in

Support and Compliance

     
Community support Included in Included in Included in
Email support Not included in Included in Included in
Designated support Not included in Not included in Included in
On Premises / BYO cloud Not included in Not included in Included in
Log retention (API & Database) 1 day 7 days 3 months
Log drain Not included in Not included in Coming soon
SOC2 Not included in Not included in Coming soon
Choose your plan Get started Get started Contact Sales Department

What platforms does Supabase support?

Supabase is available for Web , Self-Hosted and SaaS .

Top Supabase Pros & 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
4 years, 5 months ago
Con

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
fossa
3 years, 7 months ago
Con

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
4 years, 5 months ago
Pro

Hey, there are more pros and cons available, these are just the ones that people agree with the most. In total people have added 4 Supabase Pros & Cons

Top Supabase Alternatives

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.

Commercial & Proprietary
👍 Most people think Firebase is a good alternative to Supabase.

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.

Free , Commercial & Open Source , Proprietary
👍 Most people think Hasura is a good alternative to Supabase.

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.

Freemium & Proprietary
👍 Most people think Fauna is a good alternative to Supabase.

The software PostGraphile PostGraphile is removed from the Top Supabase Alternatives since you are comparing against it. If you are looking for more software, applications or projects similar to Supabase Supabase we recommend you to check out our full list containing 12 Supabase Alternatives.

Supabase Gallery