What Supabase Is (and What It's Built On)
Supabase describes itself as "the open-source Firebase alternative" — a genuinely useful shorthand, but worth unpacking what that actually means before you start building on it.
Supabase is a real Postgres database, plus a set of tools built around it. Unlike some backend-as-a-service platforms with proprietary, non-standard databases, Supabase's core is a genuine, unmodified PostgreSQL database — meaning standard SQL, standard Postgres extensions, and standard tooling all work exactly as they would against any Postgres instance.
On top of Postgres, Supabase adds: Auth (user authentication and management), Storage (file uploads), Edge Functions (serverless compute), Realtime (live data subscriptions), and an auto-generated REST/GraphQL API — each covered in its own course later in this track. You don't have to use all of them; many projects use just the database and Auth.
Row Level Security (RLS) is Supabase's core security model — genuinely important, not optional to understand. Rather than handling all authorization in a separate backend layer, Supabase encourages defining security directly as Postgres policies on your tables — this gets a full dedicated course later, since misunderstanding it is a genuinely common and serious mistake.
Open-source means you can self-host, though most projects use Supabase's managed cloud. The entire stack is open-source and can be run yourself — but the managed cloud offering (supabase.com) removes the operational burden, the same trade-off as any managed-vs-self-hosted decision.
A Supabase "Project" is your workspace — one Postgres database plus all the services built on it. Created from the Supabase dashboard, a Project is the unit everything else in this track operates within — comparable conceptually to a Railway Project, though the internals are Supabase-specific.
Why this matters for you
Because Supabase's foundation is real Postgres, everything you already know (or will learn) about SQL and relational databases transfers directly — this platform isn't hiding a different database behind a friendlier API, it's a genuine Postgres instance with real developer-experience tooling built around it.
▶️ Before the next lesson
Create a free Supabase account (supabase.com) if you don't already have one — the next lesson has you create your first real project.