Supabase
Backend-as-a-ServiceSupabase is the open-source Firebase alternative that gives you a full Postgres database, real-time subscriptions, authentication, edge functions, and file storage, all through a single dashboard and API layer. For custom web application development, Supabase is one of the fastest paths from idea to working product I've encountered. You get a real Postgres database (not some proprietary NoSQL thing), Row Level Security for fine-grained access control, auto-generated REST and GraphQL APIs via PostgREST, built-in auth with magic links and OAuth providers, and real-time listeners that push database changes to connected clients instantly. The local development experience with Supabase CLI is excellent, you can run the entire stack locally with Docker, write and test migrations, and deploy with confidence. For projects where the client needs a backend that's powerful enough for production but doesn't require a fully custom API server, Supabase is often my first recommendation.
The Backstory
Supabase was founded by Paul Copplestone and Ant Wilson in 2020. Copplestone, an Australian developer, had previously built and scaled several products and was frustrated by how Firebase locked teams into Google's proprietary database. Wilson, based in Singapore, had deep experience with Postgres at enterprise scale. They met through the open-source community and bonded over a shared conviction: that Postgres could be the foundation for a developer platform that rivaled Firebase without the vendor lock-in. They launched on Hacker News in April 2020, and the response was immediate, Supabase hit the top of HN and received hundreds of signups in the first day. Y Combinator backed them in the Summer 2020 batch. By 2023, Supabase had raised over $116 million and had hundreds of thousands of databases running on their platform. The company open-sourced everything from day one, including their dashboard, which is one of the most polished admin UIs in the developer tooling space.
Under the Hood
Supabase's secret weapon is that it's not actually one product, it's a curated collection of open-source tools wired together. The database is standard PostgreSQL. The API layer is PostgREST, an established Haskell project that auto-generates a RESTful API from your database schema. Auth is powered by GoTrue, originally built by Netlify. Real-time uses a custom Elixir server that listens to Postgres's WAL (Write-Ahead Log) for changes. Storage runs on S3-compatible object storage. Edge Functions use Deno. This architecture means you're never actually locked into Supabase, every component can be self-hosted or replaced independently. The team's philosophy is "they should be able to fire us", meaning any client can take their Postgres database and walk away at any time. This portability is a major differentiator from Firebase, where migrating off the platform requires rewriting significant portions of your application.
Visit: supabase.com