Supabase

What you'll learn

• Explain what Supabase is, how its services fit around Postgres and which API key belongs where.
• Model data in Postgres and query it from supabase-js, including joins, upserts and RPC calls.
• Protect every table with Row Level Security policies built on auth.uid() and test them.
• Add authentication with passwords, magic links and OAuth, including server-side sessions with @supabase/ssr.
• Use Storage, Realtime, Edge Functions, cron and pgvector where each one fits.
• Run a local-first workflow with the Supabase CLI and ship a secure, fast production project.

Syllabus

Supabase Foundations

1. What Supabase Is
2. Architecture and API Keys
3. Project Setup and the supabase-js Client

Working With the Database

1. Tables, Relationships and Migrations
2. Querying With supabase-js
3. Postgres Functions and RPC

Row Level Security

1. Why RLS Is Essential
2. Writing Policies With auth.uid()
3. Policy Patterns and Testing

Authentication

1. Email, Password and Magic Links
2. OAuth Providers
3. Server-Side Auth With @supabase/ssr

Storage and Realtime

1. Storage Buckets and Policies
2. Realtime Channels
3. When to Use Storage and Realtime

Edge Functions and Extensions

1. Edge Functions
2. Triggers, Webhooks and Cron
3. pgvector for Embeddings

Local Development and Workflow

1. The Supabase CLI and Local Stack
2. Migrations, Diff and Push
3. Generated Types, Seeding and Environments

Supabase in Production

1. Security Beyond RLS
2. Performance and Connection Pooling
3. Backups, Limits, Cost and Lock-In
4. A Supabase Launch Checklist