Supabase

Supabase is an open-source Firebase alternative, providing PostgreSQL DB, auth, storage, realtime, and functions as a self-hosted or managed service.

It emphasizes SQL-first with Row Level Security.

Use Supabase when:

• Needing relational DB with auth.
• Building realtime apps.
• Avoiding NoSQL lock-in.
• Self-hosting backend.

Note: Use RLS policies.

Client-side subscriptions.

Backup with pg_dump.