vlcn-io/cr-sqlite

Features

• CRDT Databases - Provides a distributed database engine that uses conflict-free replicated data types for state convergence.
• Multi-Master Replication - Implements a multi-master replication system using SQLite and CRDTs to ensure eventual consistency across distributed nodes.
• Database Synchronization - Extracts and applies changesets between database instances to synchronize state efficiently.
• Incremental Syncing - Retrieves only the modifications made since a specific version or timestamp to minimize data transfer.
• Data Replication - Replicates data across multiple master nodes using CRDTs to ensure consistency across different devices.
• Replicated Data Convergence - Ensures all replicas eventually reach the same state regardless of the order in which updates are received.
• SQLite Databases - Provides a self-contained, serverless, and transactional SQL engine based on SQLite.
• Distributed Schema Management - Updates database structures across a network of replicated nodes while maintaining synchronization integrity and consistency.
• In-Browser Database Engines - Executes a full relational database engine within the browser by compiling it to WebAssembly.
• Multi-Master Event Logs - Tracks local modifications in ordered logs to enable incremental data synchronization between peer databases.
• SQL Query Execution - Runs SQL statements and returns the resulting data as objects or arrays.
• Local Database Persistence - Ensures database content is saved to files or browser storage to survive session restarts.
• Table Replication - Synchronizes entire replicated relation tables between databases so all participants maintain an identical data set.
• WASM SQL Execution - Executes SQL operations directly in web workers or the main thread using a WASM-based engine.
• Peer Change Synchronization - Synchronizes database changes between peers by extracting local changesets and applying remote updates.
• Peer-to-Peer Database Replication - Enables direct data synchronization between devices, allowing offline editing and peer-to-peer consistency.
• Causal Dependency Tracking - Implements causal order tracking of operations to ensure consistent state convergence across distributed nodes.
• Relation Synchronization - Allows selective synchronization of specific database relations across distributed nodes.
• Table Merging - Implements configurable strategies to merge data from different database tables without conflicts.
• Property-Level Conflict Resolution - Resolves conflicts at the individual field level by applying strategies such as last-writer-wins or maximum value.
• Distributed Database Merging - Combines multiple databases into a single consistent state using conflict-free types to resolve concurrent changes.
• Offline-First Synchronization - Provides architectural support for local-first editing with automatic CRDT-based merging after reconnection.
• Schema Replication - Propagates structural database changes across distributed clusters to support consistent replication.
• Collaborative Text Modeling - Provides specialized CRDT modeling for concurrent text editing within the database.
• Database Change Subscriptions - Provides mechanisms to subscribe to and capture incremental database modifications at the table or row level.
• Database Event Listeners - Registers callbacks that trigger automatically whenever rows are inserted, updated, or deleted in the database.
• Replicated Schema Modifications - Alters table definitions for replicated relations through a controlled process to maintain synchronization integrity.
• Reactive View Bindings - Provides mechanisms that automatically update the user interface in response to underlying database changes.
• Distributed Row Ordering - Enables consistent relative ordering of rows across distributed nodes without requiring central coordination.
• Table Merge Semantics - Specifies the set-based merge type for a table to determine how rows are synchronized.
• Replicated Relation Conversions - Transforms standard database tables into replicated relations to enable multi-master replication.
• Reactive Data Queries - Implements live queries that trigger automatic interface updates when underlying table data changes.
• Schema Migration Tools - Provides utilities to generate and apply schema alter statements by diffing current and target structures.
• Schema State Diffing - Automates database structure updates by calculating the minimal set of changes required to transform schemas.
• Schema Propagation Protocols - Uses commit mechanisms to finalize and propagate structural database changes across all replicated nodes.
• Virtual Tables - Uses virtual tables to expose remote database changes as local queryable tables for seamless merging.
• Column Merge Strategies - Allows assigning specific merge types to individual columns to control how conflicting updates are resolved.
• Database Sync Transports - Transfers database changes between nodes using various networking protocols like REST and WebSockets.
• Atomic Transaction Grouping - Wraps multiple database operations into a single atomic transaction to ensure data isolation.
• Database Schema Migrations - Initiates and commits transactions to update database structures across a network of replicated nodes.
• CRDT Schema Evolutions - Updates database tables and bookkeeping metadata during schema modifications to ensure consistency across distributed nodes.
• Real-Time Collaborative Editing - Enables real-time shared state across multiple users through conflict-free data synchronization.
• Cross-Tab Synchronization - Propagates database changes across multiple open browser tabs in real time using broadcast channels.
• Misc - Listed in the “Misc” section of the Awesome Sqlite awesome list.

Star history