supabase

Supabase: The Open Source Firebase Alternative

Overview
Supabase is a comprehensive Backend-as-a-Service (BaaS) built on top of open-source technologies, primarily PostgreSQL. It offers the ease of Firebase but without the vendor lock-in.

Key Features

1. The Database (Postgres)
Unlike Firebase (NoSQL), Supabase gives you a full Postgres database.
- Relational data (SQL/Joins).
- Extensions: pgvector (AI), PostGIS (Maps).

2. Auto-generated API
It automatically generates a REST and GraphQL API based on your database schema.
- Secure logic is handled by Postgres Row Level Security (RLS) policies.

3. Realtime
Listen to database changes via WebSockets.
`supabase.from('chats').on('INSERT', handleNewMsg).subscribe()`

4. Auth & Storage
- Auth: Email, Magic Link, OAuth (Google/GitHub).
- Storage: S3-compatible file storage for images/docs.

Edge Functions
Run TypeScript (Deno) serverless functions globally for custom backend logic.

Supabase vs Firebase
- Firebase: Proprietary NoSQL. Easy to start, hard to migrate. Better analytics.
- Supabase: Open SQL. Powerful querying. Self-hostable (Docker).

Supabase is the top choice for developers who want the speed of BaaS but trust the power of SQL.