Supabase Practice Tasks
Complete these in order — each task builds on the previous one.
| Task | What You Practice |
|---|---|
| 01 — Create the Projects Table | Schema design, required columns (id/created_at/updated_at/workspace_id/created_by), CHECK constraints, indexes, soft delete, updated_at trigger, migration file |
| 02 — Write RLS Policies | All four policy types, workspace membership subquery pattern, role-based rules, INSERT WITH CHECK for created_by, UPDATE WITH CHECK to prevent workspace change, testing across all roles |
| 03 — Create Project API (RPC) | RPC function with atomic multi-step logic (insert project + task list + audit log), RAISE EXCEPTION with standard error codes, API documentation |
| 04 — Project Invite Edge Function | Edge Function structure (CORS/auth/validation/logic/response), Deno secrets, JWT validation, third-party API call (Resend email), logging rules |