Lakebase

Supabase is a hosted Postgres development platform for building production web, mobile, and AI applications, built from open-source components and available for self-hosting or local development. It provides a managed Postgres database, authentication and authorization, Row Level Security, auto-generated REST and GraphQL APIs, realtime database-change subscriptions over WebSockets, Edge Functions and serverless database functions, file storage, and an AI vector and embeddings toolkit. Its architecture combines PostgreSQL with services including PostgREST for REST APIs, GoTrue for JWT-based authentication and session management, Realtime for converting PostgreSQL replication changes to JSON broadcasts, Storage for S3-compatible file management with Postgres permissions, and pg_graphql for GraphQL access. It also provides dashboard tools such as table and SQL editors, policy management, deployment workflows, and official client libraries for JavaScript, Flutter, Swift, and Python, with additional community libraries for other languages.

Lakebed is a cloud product whose codebase was audited, cleaned up, optimized, and improved through parallel pull requests generated by AI.

PostgreSQL is an open-source relational database management system maintained by the PostgreSQL Global Development Group. It provides SQL-compliant, ACID transactions, MVCC concurrency, and extensibility through custom types, functions and extensions, and is used for general-purpose and enterprise database workloads.

Postgres is an open-source relational database created by Mike Stonebraker and subsequently maintained and enhanced by a volunteer community and companies. It is presented as a widely used database whose open ownership contributed to its adoption and continued development.