DATABASES Signal 449
DoltLite adds Git-style version control to SQLite while keeping SQL compatibility
↗
DoltLite 0.50.0 beta introduces Git-style branching, merging and time-travel to SQLite via a content-addressed storage layer while preserving the upstream SQL engine and providing binaries for macOS, Linux, Windows, browsers, mobile and server-side runtimes.
Engineers can now track schema and data changes with Git-like commits, branches and merges directly inside SQLite without a separate database server. Because DoltLite retains SQLite’s SQL execution layer but swaps the storage layer, code that relies on the pager, page format, write-ahead logging or journaling must be updated, while read-heavy workloads may benefit from lower latency.
Written by elseif from the cluster below · every claim links back to a sourceThe three things worth knowing
DoltLite 0.50.0 beta provides Git-style version control (branches, merges, diffs, time travel) through SQL functions and virtual tables while keeping SQLite’s parser, planner and VDBE unchanged.
The storage layer is replaced with a content-addressed Prolly Tree in a single-file chunk store, which preserves SQL compatibility but breaks dependence on SQLite’s pager, page format and journaling.
Benchmarks show read latency lower than SQLite’s on a file-backed workload, write latency is traded for history, and the format has survived 57 releases with a promised migration path for future changes.
THE CLUSTER