Supabase

What it is

Supabase is an open-source Firebase alternative built on Postgres. You get a real Postgres database, plus auth (with social login, magic links, SSO), file storage, edge functions, realtime subscriptions, and a REST/GraphQL API auto-generated from your schema. It's a backend-as-a-service that takes Postgres seriously.

Who it's for

• Teams building full-stack apps who want to avoid writing auth from scratch
• Developers who want Firebase convenience but with SQL instead of NoSQL
• Projects that need realtime features (presence, live feeds) without custom WebSocket infra
• Open-source advocates who want to self-host their backend

The good

The auth system is exceptional. Row-level security (RLS) policies in Postgres + built-in user management + social providers + magic links. This is the best out-of-the-box auth-plus-database combo for most apps.

Auto-generated APIs are genuinely useful. PostgREST turns your schema into a REST API. The JS client library is polished and reactive. Realtime is built on Postgres LISTEN/NOTIFY via websockets — no separate infrastructure.

Genuinely open source. You can self-host the entire stack. This isn't "open core" — the full product is Apache 2.0. The self-hosting path is documented and works.

Dashboard and Studio are excellent. The table editor, SQL editor, and log viewer are best-in-class. Supabase Studio would be a worthy product on its own.

The bad

Free tier pauses after 1 week of inactivity. This is a dealbreaker for side projects you revisit occasionally. Resume time is 15-30 seconds, which means users hit a slow cold start. Neon's free tier doesn't pause.

Pro tier at $25/mo. That's per-project. If you have multiple projects, costs stack fast. Neon's equivalent is $19/mo.

RLS is powerful but sharp. Misconfigured row-level security policies are a real security risk that's easy to get wrong. The "all users can read everything" footgun is documented but still traps people.

Vendor lock-in risk. The auth system, storage, and realtime are all Supabase-specific. Pure Postgres queries migrate fine, but your auth tables and storage references don't.

Pricing reality

Free: real for development and new projects, but the pause-on-inactivity is a genuine production risk. Pro at $25/mo per project: reasonable for a single production app. If you only need Postgres, you're paying $25 for features you don't use — use Neon at $19.

Verdict

Supabase is the right choice when you're building an app and want the full backend (auth + db + storage + realtime) in one place without stitching it together. If you only need Postgres, Neon is cheaper, faster, and doesn't pause on you. The distinction matters — pick based on what you actually need.