Supabase

Out-of-the-box open source backend: With PostgreSQL as the core, it provides authentication, real-time, storage, automated APIs and Serverless, allowing you to quickly deliver modern Web/mobile/AI applications with minimal backend workload. upbase is an open source "Firebase-style" backend as a service (BaaS) with PostgreSQL as its core and integrates backend capabilities such as database, authentication, real-time, file storage, Serverless functions and automatically generated APIs into a ready-to-use platform. It supports both hosted and self-hosted models, suitable for quickly building Web / Mobile / AI applications. core functions · Hosted PostgreSQL -A relational database is centered and supports transactions, views, triggers, and stored procedures. · Auth (Identity Authentication)-registration/login, JWT session management, social login and multiple authentication policies. · Automatic API (REST / GraphQL)-Automatically generates usable REST (PostgREST) and GraphQL interfaces based on database structures. · Realtime (real-time subscription)-listens for database changes and pushes them to the client via WebSocket to achieve real-time UI. · Storage-Class S3 file storage that supports permissions and signature URLs. · Edge / Serverless Functions -Deploy custom backend logic (HTTP functions) at the edge or near-end. · Vector/embedding and AI support-Supports storing and retrieving vector embeddings for AI scenarios such as semantic search/recommendation. · Dashboard & Management Console-Visually manage databases, permissions, logs and project settings. Key features and advantages · SQL-first + Firebase experience: You can use familiar SQL to do complex queries and enjoy the out-of-the-box BaaS process. · Row-level security (RLS): Use PostgreSQL's RLS for fine-grained data permission control, which has high security. · Open source & customizable: Apache-2.0 license, complete source code can be self-hosted and secondary developed. · Multi-lingual SDK: The official/community SDK covers JS/TS, Flutter, Swift, Python, Go, C#, etc. · Hosted or self-hosted: Supabase's official hosting service can also be fully run in a private environment. · Automated operations and maintenance tool chain: Local development mirroring, migration, backup and deployment scripts support the development-to-production process. · Built-in real-time capabilities: Data-driven real-time interactions can be achieved without an additional WebSocket layer. · Adapt to AI applications: Built-in or compatible vector indexing/embedding workflows make it easy to build semantic retrieval and intelligent assistants. Typical application scenarios · Quickly build MVP /prototype projects (very short launch cycle) · JAMstack /Front-end separation application (front-end directly operates back-end through API) · Small and medium-sized production applications (stable operation with good architecture and tuning) · Data-sensitive scenarios requiring self-hosting or compliance controls (financial/medical/corporate) · Prototypes and experiments of AI-driven products such as semantic search and chat bots