Supabase is an open-source development platform designed to provide a Firebase-like experience by aggregating several enterprise-grade tools centered around a hosted PostgreSQL database. The architecture leverages a modular approach to offer various backend services, including GoTrue for JWT-based authentication and session management, and PostgREST to automatically transform PostgreSQL databases into RESTful APIs. For real-time capabilities, the platform utilizes an Elixir-based server called Realtime, which polls PostgreSQL's native replication functionality to broadcast database changes (inserts, updates, and deletes) as JSON via WebSockets. Additional core components include pg_graphql for GraphQL API exposure, a dedicated Storage API for managing files in S3 with PostgreSQL-integrated permissions, and Envoy as a high-performance edge proxy. The ecosystem supports multiple programming languages through a modular client library strategy; official bundled clients are available for JavaScript (TypeScript), Flutter, Swift, Python, and Kotlin, while community-driven implementations exist for languages such as C#, Go, Java, Ruby, and Rust. This integrated stack allows developers to manage databases, authentication, file storage, and edge functions through a unified dashboard or via local development environments.

Read original