Dev Productivity & ToolsSeries
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.
SupabasePostgresBackend
#Supabase
10 posts
Dev Productivity & ToolsSeriesProject setup, CLI and environment variables
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.
SupabaseCliEnv
Dev Productivity & ToolsSeriesPostgres schema and table design
2026-03-17·3 min read
Table design: naming, UUID vs serial, relations; example schema conversations, messages. Prep for RLS and PostgREST.
SupabasePostgresSchema- Dev Productivity & ToolsSeries
Migrations: write and apply
2026-03-17·3 min read
Write SQL migrations, folder and naming; apply via CLI or Studio; basic rollback. Schema versioned, reproducible.
SupabaseMigrationsPostgres - Dev Productivity & ToolsSeries
Auth: JWT, session and backend integration
2026-03-17·3 min read
Supabase Auth, JWT; verify JWT on backend (NestJS, Express, FastAPI). Session and refresh. Secrets server-side only.
SupabaseAuthJwt - Dev Productivity & ToolsSeries
Prisma + Supabase: connect and sync schema
2026-03-17·3 min read
Configure Prisma for Supabase; introspect vs migrate; avoid conflicts with Supabase migrations. One source of truth for schema.
SupabasePrismaOrm - Dev Productivity & ToolsSeries
Row Level Security (RLS) and policies
2026-03-17·3 min read
What RLS is; enable RLS, write SELECT/INSERT/UPDATE/DELETE policies; test. Secure by default, least privilege.
SupabaseRlsSecurity - Dev Productivity & ToolsSeries
API: PostgREST vs custom API and when to use which
2026-03-17·3 min read
PostgREST auto API; when to use custom API (own backend). Clear REST contract; separate consumer and data.
SupabaseApiPostgrest - Dev Productivity & ToolsSeries
Deploy, CI/CD and multi-project
2026-03-17·3 min read
Deploy migrations safely; CI/CD (secrets, branch); multiple projects dev/staging/prod; secure keys; deploy checklist.
SupabaseDeployCicd - Dev Productivity & ToolsSeries
Series: Supabase from setup to deploy
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.
SupabasePostgresBackend