rbbydotdev/cr-sqlite

This is a fork, a modified copy, of an existing project called cr-sqlite, which stands for Convergent, Replicated SQLite. The original project adds multi-writer and conflict-resolution capabilities to SQLite, a widely used database that normally only handles one writer at a time. This fork extends it further by adding support for collaborative text editing, meaning multiple people can type into the same text field simultaneously and their changes will eventually merge together correctly, even if they were offline when editing. The core idea behind collaborative text editing is a CRDT, which stands for Conflict-free Replicated Data Type. This is an algorithm that guarantees two people editing the same document at the same time will always end up with the same result after their changes sync, so no one's edits get silently lost or corrupted. The specific algorithm used here is called Fugue. A single function, crsql_as_text_crdt, is all you need to turn any text column in your SQLite database into a Fugue-managed collaborative field. The project ships as a WASM extension, meaning it can run directly in a web browser without a server. There is a browser demo where you can open two editing panes, type into either, and watch them stay in sync. You can also take one peer offline, make diverging edits, then bring it back online to see convergence happen. A benchmark page measures how fast the system handles different typing scenarios, with individual keystrokes staying well under one millisecond even in large documents. The project is built in Rust with a C layer inherited from the upstream codebase, and is distributed under the MIT license.