clockworklabs/SpacetimeDB
SpacetimeDB
SpacetimeDB is a stateful, real-time database platform that executes application logic directly within the database engine. By unifying data storage and business logic, it allows developers to build applications where state transitions are processed through atomic, server-side functions. The platform maintains persistent connections to stream incremental updates to clients, ensuring that local caches remain synchronized with the server state at all times.
The platform distinguishes itself by generating type-safe client interfaces directly from server-side schema definitions, ensuring consistent data structures across the entire application stack. It utilizes persistent event sourcing to record every state change to disk, which facilitates full data recovery and historical auditing. Furthermore, the system supports language-agnostic module deployment, allowing custom application logic to run within the database environment regardless of the source programming language.
Beyond its core execution model, the platform provides a comprehensive suite of tools for managing the full application lifecycle. This includes centralized identity and access management, task scheduling for recurring operations, and granular team-based project administration. Developers can interact with the system through a command-line interface that supports local development, testing, and the generation of type-safe bindings.
The platform offers flexible deployment options, supporting both managed cloud services and self-hosted infrastructure. It includes built-in monitoring and observability features, such as real-time log streaming and performance metrics, to assist in tracking data changes and function execution.
Features
- Real-time Databases - Executes application logic directly within the database engine while streaming state changes to clients via persistent connections.
- Database Execution Engines - Executes custom application logic directly within the database engine to unify data storage and business logic.
- Relational Database Management Systems - Implements a relational database engine that supports atomic transactions, SQL queries, and structured data storage.
- Type-Safe Database Clients - Generates strongly-typed client interfaces from server-side schema definitions to ensure consistent data structures across the application stack.
- Real-Time Frameworks - Enables building stateful applications with integrated server-side logic and native real-time data synchronization to clients.
- Atomic Transactions - Processes state transitions through isolated functions that automatically roll back changes on failure to maintain data integrity.
- Real-time Data Synchronization - Maintains live data consistency between server-side state and client-side caches through automated, persistent subscription streams.
- Type-Safe Client Generators - Generates type-safe client interfaces directly from server-side schema definitions to ensure consistent data structures across the application stack.
- Event Sourcing - Records every state change to disk by default to enable full data recovery and historical auditing of application state.
- Reactive State Subscriptions - Maintains persistent connections to push incremental database updates to clients, keeping local caches synchronized with server state.
- Database Schema Definitions - Enables the definition of structured data collections using tables, primary keys, and constraints.
- Type-Safe Binding Generators - Generates type-safe client interfaces from server-side definitions during the build process to ensure consistent data structures.
- Database Lifecycle Management - Streamlines the operational lifecycle of database modules through integrated command-line tools and local development environments.
- Websocket Connection Managers - Maintains persistent websocket connections to stream incremental updates while handling authentication and lifecycle events.
- Identity and Access Management Servers - Provides centralized user registration, authentication flows, and token issuance to verify identities and restrict access.
- Server-Side Logic Frameworks - Supports writing custom server-side application logic in standard programming languages to handle business rules and state transitions.
- Database Systems - Relational database for multiplayer games.
- Historical Data Querying Interfaces - Records every state change to disk to facilitate full data recovery and historical auditing of application state.
- SQL Query Interfaces - Allows developers to execute standard SQL queries or use type-safe query builders to retrieve and filter records.
- Language-Agnostic Runtimes - Supports language-agnostic module deployment, allowing custom application logic to run within the database environment regardless of the source language.
- Access Control - Applies server-side filters and visibility rules to database queries to restrict client access to specific data subsets.
- Task Scheduling - Allows developers to trigger server-side logic at specific future times by defining scheduling rules within data tables.
- Cloud Deployment Platforms - Provides managed cloud hosting environments for deploying and scaling database applications without infrastructure overhead.
- Local Database Development Tools - Provides a standalone server instance to facilitate development and testing of application logic and data structures.
- CLI Development Tools - Provides a command-line interface to initialize projects, manage local server instances, and generate type bindings.
- Team Management - Allows users to group related databases into projects and manage granular access permissions for team members.
- Monitoring and Observability - Offers real-time log streaming, performance metrics, and execution callbacks to monitor database state and function performance.
