Supabase Explained: The Open-Source Firebase Alternative

Introduction

Firebase (the batch 18 post) gives you a backend as a service — but on Google's platform, with a NoSQL database. Supabase, launched in 2020, offers the same idea with a different philosophy: open source, built on PostgreSQL, and designed so you can self-host it if you ever want to leave. Its pitch is "Firebase, but on Postgres" — and for developers who want relational data with backend-as-a-service convenience, that combination is exactly the appeal.

What you get in one project

A Supabase project bundles the pieces a typical app needs:

  • Postgres database — a full relational database (the PostgreSQL post's engine) with a table editor, SQL access, and Row Level Security rules that decide who can read or write each row
  • Authentication — email, OAuth (Google, GitHub), and magic links, with user data stored in Postgres tables you can query like any other data
  • Storage — file uploads with access policies, for avatars, images, and documents
  • Realtime and Edge Functions — live updates when data changes, and small serverless functions for jobs that can't run in the browser
  • Auto-generated APIs — every table instantly gets a REST API, so frontend code reads and writes data with a client library instead of a custom server

The pattern mirrors Firebase: configure a project, add its client library, and call its services from frontend code — except the database underneath is relational, so joins, constraints, and transactions (the SQL and MySQL posts) all work as expected.

The honest trade

Supabase's trade is youth and depth: it is younger than Firebase, so its ecosystem and documentation are smaller, and its power comes with Postgres concepts — Row Level Security, in particular, must be understood, because a misconfigured policy can expose data. Self-hosting is possible but is real operational work, not a one-click escape. The rule of thumb: Supabase when you want backend-as-a-service convenience with relational data and an open-source exit; Firebase when you want the most mature ecosystem and are happy with NoSQL.

Takeaway

Supabase is Firebase's idea on Postgres: auth, storage, realtime, and auto-generated APIs, open source and self-hostable. If Firebase's NoSQL model ever felt like the wrong fit, Supabase is the alternative built for the relational world.

 

Comments

Post a Comment

Popular posts from this blog

Swift Explained: Apple's Language for iPhone, Mac, and More

Introduction Swift is Apple's language for its platforms: iPhone, iPad, Mac, Apple Watch, and Apple TV. Introduced in 2014 to replace the older Objective-C, it was designed to be safe, fast, and — unusually for a systems language — genuinely pleasant to read and write. Even if you never ship an app, Swift teaches one idea every developer should understand: optionals. Optionals: saying "this might be missing" Most bugs in app development come from one cause: code assuming a value exists when it does not. Swift makes that assumption impossible to hide. A value that might be missing is wrapped in an Optional, and you must unwrap it before use. var nickname: String? = nil nickname = "Waqas" if let name = nickname { print("Hello, \(name)!") } else { print("No nickname set.") } String? means "a String, or nothing". The if let unwraps it safely: inside the block, name is guaranteed to exist. There is no way to accidentally us...
Read more

Flutter Explained: One Codebase, Every Screen

Introduction Flutter is Google's framework for building apps from a single codebase: write once in Dart, and ship to iOS, Android, web, Windows, macOS, and Linux. It powers apps from Google Pay to the New York Times crossword app. Its core idea is simple and radical: everything on screen is a widget, and the interface is rebuilt from data whenever that data changes. Everything is a widget In Flutter, there are no separate concepts for layout, styling, and controls — everything is a widget, nested inside other widgets like HTML elements, but in code: import 'package:flutter/material.dart'; class Greeting extends StatelessWidget { @override Widget build(BuildContext context) { return Center( child: Text( 'Hello, Sara!', style: TextStyle(fontSize: 24, color: Colors.teal), ), ); } } Center positions its child, Text displays words, TextStyle styles them — each a widget, composed by nesting. Layout widgets (like Row, Column, ...
Read more

Go Explained: Simple Code That Runs Fast

Introduction Go was built at Google for a specific frustration: large programs that were slow to build and hard to read. The answer was a language that is deliberately small — fewer features, but the right ones, done well. If you know one programming language already, Go will feel familiar within an hour. The interesting parts are not the syntax, but two ideas: goroutines and channels. Goroutines: cheap concurrency Most languages make running things at the same time feel heavy — threads, thread pools, and careful setup. A goroutine is Go's lightweight version: you start one by writing go in front of a function call. package main import ( "fmt" "time" ) func say(text string) { for i := 0; i < 3; i++ { fmt.Println(text) time.Sleep(100 * time.Millisecond) } } func main() { go say("hello") say("world") time.Sleep(500 * time.Millisecond) } The go say("hello") line does not wait — it st...
Read more