Supabase is an open-source Firebase alternative built on top of PostgreSQL. It provides a managed PostgreSQL database with built-in authentication, real-time subscriptions, storage, edge functions, and auto-generated REST/GraphQL APIs. Why Supabase? Full PostgreSQL — Not a subset. You get extensions, RLS, functions, triggers, everything. Auto-generated APIs — RESTful API via PostgREST and GraphQL instantly from your schema. Real-time — Subscribe to database changes via WebSockets. Auth — Built-in email/password, OAuth (Google, GitHub, etc.), magic links, and MFA. Storage — S3-compatible file storage with RLS policies. Edge Functions — Deno-based serverless functions. Getting Started Sign up at supabase.com Create a new project (choose region, set database password) Use the SQL Editor to…
Key Takeaways
Supabase is a managed PostgreSQL with auth, real-time, storage, and auto-generated APIs.
RLS is mandatory in Supabase — use auth.uid() in policies for user-scoped access.
Connection pooling (port 6543) is recommended for serverless and edge deployments.
Real-time subscriptions use ALTER PUBLICATION to enable change tracking on tables.