Why Supabase is the open-source Firebase alternative

Introduction

Supabase is a tool that helps you build apps quickly by giving you ready-made backend services. It is open-source, which means anyone can see and change its code. This makes it a friendly and flexible choice compared to Firebase, which is closed and controlled by one company.

You want to build an app with a database, user login, and storage without writing all backend code.

You prefer using software that is open and can be customized or self-hosted.

You want to avoid vendor lock-in and keep control over your app's backend.

You need a backend that works well with SQL databases and real-time features.

You want a free or low-cost alternative to Firebase with similar features.

Syntax

Supabase

supabase start

# This command starts a local Supabase backend with database, authentication, and storage services.

Supabase uses PostgreSQL as its database, which is powerful and widely used.

You can interact with Supabase using simple APIs for authentication, database, and storage.

Examples

Starts the local Supabase backend services for development.

Supabase

supabase start

Logs you into your Supabase account to manage projects.

Supabase

supabase login

Initializes a new Supabase project in your current folder.

Supabase

supabase init

Sample Program

This example shows how to start Supabase locally, create a simple table for tasks, add a task, and then get the list of tasks. It demonstrates how Supabase uses a real SQL database you can control.

Supabase

# Start Supabase locally
supabase start

# Create a new table in the database
CREATE TABLE todos (
  id SERIAL PRIMARY KEY,
  task TEXT NOT NULL,
  completed BOOLEAN DEFAULT FALSE
);

# Insert a todo item
INSERT INTO todos (task) VALUES ('Learn Supabase');

# Query the todos
SELECT * FROM todos;

Important Notes

Supabase is built on open standards like PostgreSQL, making it easy to use and extend.

Because it is open-source, you can host Supabase yourself or use their cloud service.

Supabase provides real-time updates, authentication, and storage out of the box, similar to Firebase.

Summary

Supabase is an open-source backend platform that offers Firebase-like features.

It uses PostgreSQL, giving you a powerful and familiar database system.

Supabase is flexible, transparent, and helps you avoid vendor lock-in.