Supabase

Supabase is an open source backend-as-a-service platform that provides developers with a fully managed PostgreSQL database, authentication, file storage, edge functions, and realtime capabilities. Often described as the open source alternative to Firebase, Supabase takes a fundamentally different approach by building on top of the battle-tested PostgreSQL database engine rather than a proprietary NoSQL store.

At the heart of Supabase is a full PostgreSQL database with all the power and flexibility that comes with it. Developers get a relational database with support for complex joins, foreign keys, triggers, stored procedures, and extensions. The Supabase Table Editor provides a spreadsheet-like interface for managing data without writing SQL, but experienced developers can also interact directly with the database using their preferred SQL client or the built-in SQL editor.

Supabase Auth is a comprehensive authentication solution that supports email and password login, magic links, OAuth providers (Google, GitHub, Apple, Twitter, and many more), phone-based OTP, and SAML for enterprise SSO. It integrates tightly with PostgreSQL through row-level security (RLS) policies, allowing developers to write database security rules that reference the authenticated user's identity, enabling powerful and fine-grained access control without additional middleware.

Supabase Storage provides an S3-compatible object storage solution for managing files such as images, videos, documents, and other binary data. It integrates with the authentication system so that access to storage buckets and objects can be controlled through RLS policies, using the same security model as the database. Transformations such as image resizing are available through a built-in CDN layer.

Realtime is one of Supabase's most beloved features. Using PostgreSQL's logical replication, Supabase can broadcast database changes as events over WebSocket connections, enabling developers to build live-updating dashboards, collaborative applications, and multiplayer experiences. The Realtime system also supports broadcast channels for custom messaging between clients and presence tracking for collaborative features.

Supabase Edge Functions are server-side TypeScript functions deployed on the Deno runtime at the edge, close to users worldwide. They are ideal for handling webhooks, running custom business logic, integrating with third-party APIs, and performing operations that should not be exposed to the client. Functions are deployed using the Supabase CLI and can be tested locally before deployment.

The Supabase client libraries for JavaScript, TypeScript, Python, Swift, Kotlin, Flutter, and C# provide type-safe, auto-generated access to the database, auth, and storage APIs. The auto-generated TypeScript types feature generates TypeScript interfaces directly from your database schema, enabling full type safety from the database to the frontend without any manual type definition work.

Supabase can be self-hosted using Docker and is fully open source, giving organizations the option to run it on their own infrastructure for maximum data control. The managed cloud platform handles all infrastructure concerns including backups, monitoring, upgrades, and scaling, with a generous free tier that makes it accessible for individual developers and startups.