supabase/realtime

Features

• Database Change Streaming - Captures database changes from the write-ahead log to stream row-level modifications to connected clients in real time.
• Change Data Capture - Monitors database write-ahead logs to stream row-level modifications to external applications.
• Database Change Subscriptions - Allows clients to subscribe to database modifications over WebSockets for immediate application updates.
• Real-Time Data Streaming - Provides real-time data streaming by monitoring database logs to push updates to authorized clients.
• Presence Tracking - Tracks and broadcasts the online state of users to coordinate shared activity in real time.
• Room-Based Message Routing - Organizes real-time communication into named streams to isolate data traffic between different sets of clients.
• Broadcast Messaging - Provides a low-latency layer for sending ephemeral messages and presence updates between connected clients.
• PubSub Messaging Systems - Pushes real-time updates from the server to subscribed clients over persistent WebSocket connections.
• Real-Time Messaging Protocols - Uses a structured JSON message format to handle subscriptions and broadcasts between clients and the real-time server.
• Real-Time Synchronization - Maintains and synchronizes shared application state across multiple connected clients using persistent connections.
• JWT Session Management - Generates JSON Web Tokens to maintain user sessions and verify identity across network requests.
• Identity-Based Access Control - Controls access to resources and actions based on verified user identity and assigned permissions.
• Row-Level Security - Enforces data access controls by mapping client identities to database security policies during the streaming process.
• User Authentication Systems - Verifies user identities using various methods including passwords, magic links, one-time passwords, and social logins.
• Collaborative Presence States - Manages transient user presence and metadata in memory for low-latency synchronization of active user states.
• Presence Tracking - Provides a coordination layer for tracking and sharing the online status and metadata of active users.
• Schema-Driven API Generators - Automatically generates web interfaces and endpoints directly from a data schema for CRUD operations.
• Identity Provider Integration - Connects to external OAuth2 or OIDC-compatible services to enable sign-in via social or enterprise accounts.
• Real-time Sync Engines - Implements a system that listens to database changes and pushes updates to clients via WebSockets.
• Semantic Search Engines - Enables the conversion of text into vector embeddings and retrieval pipelines to find information based on meaning.
• File Managers - Provides a visual dashboard to upload, browse, and organize files with folder management.
• S3-Compatible Cloud Storage - Manages file uploads and delivery using S3-compatible protocols and a global CDN.
• Database Branching - Creates isolated database copies synced with version control for testing changes in preview environments.
• Database Extensions - Integrates specialized database capabilities such as vector search and geospatial data through extensions.
• Database Migration Management - Applies schema changes across environments to maintain consistency between local and production databases.
• Spreadsheet-Like Editors - Provides a spreadsheet-like interface to view and edit database records, relationships, and JSON columns.
• File Upload Management - Provides a user interface and system for selecting and uploading files to cloud storage.
• Object Storage - Implements S3-compatible object storage for managing unstructured files, datasets, and embeddings.
• Read Replicas - Distributes read requests across regional replicas to reduce latency and increase database throughput.
• SQL Query Interfaces - Provides a dashboard interface for writing and executing raw SQL commands against the database.
• Vector Embedding Indexes - Stores high-dimensional vector embeddings in optimized indexes to support AI-powered similarity searches.
• Vector Similarity Search - Identifies nearest neighbor vectors using distance metrics and indexing strategies like HNSW.
• Filtered Similarity Searches - Constrains vector similarity search results using relational or JSONB metadata filters.
• Vector Storage - Stores high-dimensional vector embeddings alongside relational data to support hybrid SQL queries.
• Local Development Stacks - Provides a local environment with database, authentication, and storage services for offline testing.
• Team-Scoped Access Control - Manages shared billing and assigns permissions to team members by grouping projects into organizations.
• Type Definition Generators - Automatically creates TypeScript definitions from the database schema to ensure type safety.
• Application Environment Provisioning - Deploys a dedicated database, authentication system, API layer, and storage instance for a single application.
• CI CD Pipelines - Automates the deployment of project changes from version control branches using integrated pipelines.
• Point-in-Time Recovery - Restores database states to specific historical moments using automatic daily backups and log replaying.
• Deployment Configuration - Synchronizes local settings and schema changes to remote platforms to maintain environment consistency.
• Infrastructure as Code - Defines and deploys project resources as code using a Terraform provider.
• Preview Environments - Generates isolated temporary environments for pull requests to validate database changes before merging.
• Real-time Messaging - Provides the WebSocket infrastructure required to build real-time messaging and chat interfaces.
• Content Delivery Networks - Serves stored content from a global network of edge locations to reduce end-user latency.
• Logic Customizers - Allows the injection of custom logic into the signup or login sequence by triggering functions during the process.
• Multi-Factor Authentication - Implements TOTP-based secondary verification steps during the login process to increase account security.
• File Access Policies - Enforces read and write permissions for cloud storage objects using custom security policies.
• User Identity Management - Provides a visual administrative dashboard to manage the lifecycle of user accounts and identities.
• Authentication UI Components - Provides pre-made UI components for login and signup screens that connect directly to the identity provider.
• Serverless Functions - Executes TypeScript code in globally distributed serverless environments to minimize latency for HTTP endpoints.
• Data and Databases - Real-time database synchronization and broadcasting via WebSockets.

Istoric stele