Technology
DoltHub releases Beta version of DoltLite SQLite fork
The project integrates Git-style version control into a modified SQLite engine built primarily with automated software agents.
The short version
- DoltHub launched version 0.50.0 of DoltLite, marking its Beta release five months after the project began.
- The software was constructed using roughly 2,000 pull requests generated via Gas Town, an AI agent orchestrator.
- DoltLite replaces SQLite's B-tree storage layer with a Prolly Tree, providing Git-style branching, merging, diffing, and synchronization while maintaining SQL compatibility.
- The main trade-off is write performance, with small autocommit file writes running about 3.1 times slower than standard SQLite.
Key facts
- DoltLite reached Beta status with version 0.50.0, five months after its initial launch.[Hacker News]
- The project was created using Steve Yegge's agent orchestrator, Gas Town, taking approximately 2,000 pull requests.[Hacker News]
- DoltLite is a fork of SQLite that keeps the stock SQL parser, analyzer, and file system interaction layer, but replaces the standard B-tree layer with a Prolly Tree backed by a single file chunk store.[Hacker News]
- The engine passes 100% of the sqllogictest suite and 99.46% of SQLite's 892,277 TCL-based acceptance tests, with 4,809 known divergences.[Hacker News]
- Performance benchmarks indicate file-backed DoltLite database reads match standard SQLite performance, while small autocommit writes run 3.1 times slower.[Hacker News]
- The Beta release establishes storage format stability, committing to migration paths for any future breaking format changes after 12 previous breaking format changes.[Hacker News]