Syncular Introduces Offline-First SQL Sync with TypeScript and Rust Cores

Offline-First Data Synchronization

Syncular is a new solution for offline-first SQL synchronization. It allows client applications to maintain a local SQLite database, utilizing OPFS in browsers and native SQLite for other environments. This setup enables applications to function without a constant network connection.

Data Consistency and Architecture

The system handles data writes through an optimistic outbox, ensuring that operations are recorded locally before synchronization. A single, ordered commit log on the server acts as the authoritative source of truth for all data. Synchronization occurs over WebSockets.

Dual Core Implementation and Testing

Syncular is built with two core implementations, one in TypeScript and one in Rust. These cores are kept in lockstep through an implementation-agnostic conformance suite and a spec-first development approach, where the specification dictates the code's behavior. The project emphasizes rigorous testing, including fault injection and loopback in-memory transports.

Developer Workflow and AI Assistance Policy

Developers can set up a Syncular application using `bun create syncular-app`. The project also outlines a policy for AI assistance, welcoming LLMs for tasks like writing tests, reproductions, benchmarks, and documentation, provided submissions are reviewed and understood by human contributors.