Supabase
My default BaaS. Auth, PostgreSQL DB, RLS, Edge Functions, Storage, Realtime, all in one.
Strengths
- Auth + DB + RLS + Storage + Realtime in a single integrated platform
- Native PostgreSQL, full SQL power, extensions (pgvector, PostGIS)
- Built-in RLS (Row Level Security), security at the database level
- Full admin dashboard, CLI migrations, auto-generated TypeScript types
- Excellent DX, idiomatic TypeScript SDK, Realtime in 5 lines
Limitations
- Free tier capped at 2 active projects, problem from the 3rd project
- Auto-pause after 7 days of inactivity (free), dangerous in production
- Edge Functions limited (Deno runtime, cold starts, no native npm packages)
- Paid scale is expensive: $25/month just to remove auto-pause
Best for
- SPAs / web apps with auth + structured relational data
- Fast prototypes needing production-ready setup from day one
- Apps requiring real-time notifications or live subscriptions