Building SQLite with a Small Swarm
Summary
The post details an experiment where Claude, Codex, and Gemini collaboratively build a SQLite-like engine in Rust, totaling ~19k lines of code and a full feature set (parser, planner, executor, storage, WAL, joins, transactions) with 282 tests passing. It describes a distributed workflow with bootstrap and worker phases, emphasizing strict task boundaries and high test cadence as keys to throughput. It also discusses replication steps, coordination challenges, limitations, and future work.