Supabase overview
2026-03-173 min read
Supabase is an open-source BaaS on PostgreSQL. This post covers: database, auth, API, storage, Realtime; place in stack and when to choose.
10 posts

2026-03-17·3 min read
Supabase is an open-source BaaS on PostgreSQL. This post covers: database, auth, API, storage, Realtime; place in stack and when to choose.

2026-03-17·3 min read
Create Supabase project, install CLI, folder structure; manage env (URL, anon key, service role key) securely. No secrets in repo.

2026-03-17·3 min read
Table design: naming, UUID vs serial, relations; example schema conversations, messages. Prep for RLS and PostgREST.

2026-03-17·3 min read
Write SQL migrations, folder and naming; apply via CLI or Studio; basic rollback. Schema versioned, reproducible.

2026-03-17·3 min read
Supabase Auth, JWT; verify JWT on backend (NestJS, Express, FastAPI). Session and refresh. Secrets server-side only.

2026-03-17·3 min read
Configure Prisma for Supabase; introspect vs migrate; avoid conflicts with Supabase migrations. One source of truth for schema.

2026-03-17·3 min read
What RLS is; enable RLS, write SELECT/INSERT/UPDATE/DELETE policies; test. Secure by default, least privilege.

2026-03-17·3 min read
PostgREST auto API; when to use custom API (own backend). Clear REST contract; separate consumer and data.

2026-03-17·3 min read
Deploy migrations safely; CI/CD (secrets, branch); multiple projects dev/staging/prod; secure keys; deploy checklist.

2026-03-17·2 min read
Intro to 10-post Supabase series (Postgres BaaS): overview, setup, schema, migrations, auth, Prisma, RLS, API, Realtime/Edge, deploy.