Supabase vs. Firebase — Which Backend in 2026?

Supabase vs. Firebase compared honestly — database, auth, pricing, vendor lock-in, and which one to pick for your project.