Alternative

Supabase vs Heroku Postgres

2022-05-26

4 minute read

What is Heroku Postgres?

Heroku is a cloud application platform that offers managed PostgreSQL as a service. They offer 5 levels of Postgres support from the Hobby Tier up to the Shield Tier, each with different levels of features and pricing. Heroku announced that starting November 28, 2022, they will stop offering free product plans and will shut down free dynos and data services. Since the announcement, developers started migrating their projects to Supabase.

What is Supabase?

Supabase also offers managed Postgres, the main difference is that with each deployment you also get:

How are they similar?

Heroku Postgres and Supabase both offer:

What are the differences?

Core Features

These are some of the key differences between Heroku Postgres and Supabase in terms of features:

  • Supabase is more than just the raw database, it also comes with:
    • Connection pooling so that you won’t run out of connections in a serverless environment.
    • Auto-generated APIs based on your schema, so you can communicate with your database directly from the client.
    • Realtime API is useful for when you want to subscribe to changes to your database over websockets.
    • Auth API can be used to leverage Postgres’s Row Level Security model, and control access to sensitive data on a per user, or per group level.
    • Functions can be deployed out to the edge directly from the Supabase CLI, which means you can run sensitive business logic or transformations in a serverless fashion.
      • You can also deploy edge functions to Heroku using their Dynos runtime in conjunction with something like Fastly.
    • File Storage is useful for when your app needs to store large files and folders that aren’t suitable for storing within Postgres itself.
    • A spreadsheet-like web interface for building your schemas and inspecting data.

Pricing

The two services price quite differently, the key differences being:

Supabase’s free plan also includes a dedicated Postgres instance, and the best bit is you can upgrade to pro later without any interruptions.

Global Deployments

You may have strict data regulations that you must comply with, so choosing your region can be very important. Here’s how the deployment options stack up:

How to migrate from Heroku Postgres to Supabase

Migrating is surprisingly simple. You just need to use the standard Postgres pg_dump and psql tools to export your Heroku database and import to Supabase. We created a handy guide for migrating from Heroku to Supabase.

Share this article

Build in a weekend, scale to millions