Heldinhow Supabase Backend
Overview
Supabase provides an open-source Firebase alternative with PostgreSQL, authentication, and real-time capabilities. This skill should be invoked when building backends needing quick setup, real-time features, or PostgreSQL power.
Core Principles
- PostgreSQL Power: Full PostgreSQL capabilities
- Row Level Security: Fine-grained access control
- Real-Time: Live subscriptions to database changes
- Auth Built-in: User authentication included
Preparation Checklist
- Create Supabase project
- Design database schema
- Plan RLS policies
- Choose authentication providers
Step-by-Step Process
- Setup: Create Supabase project
- Schema: Define tables and relationships
- RLS: Configure Row Level Security policies
- Auth: Set up authentication
- Real-Time: Implement subscriptions
- Deploy: Connect frontend
Do's and Don'ts
- ✅ Do use RLS for all tables
- ✅ Do design proper schema
- ✅ Do leverage real-time features
- ❌ Don't skip RLS policies
- ❌ Don't expose admin keys
- ❌ Don't ignore vendor lock-in
Anti-Patterns
- No RLS: Leaving tables unprotected
- Admin Exposure: Using service role incorrectly
- Poor Schema: Not using proper PostgreSQL
- No Backups: Not planning data recovery