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.