How Turso Made SQLite 4x Faster at Writes

Turso has rewritten SQLite in Rust to overcome its single-writer limitation through Multi-Version Concurrency Control (MVCC). Inspired by Microsoft's Hekaton, the implementation tracks row versions in memory, enabling multiple concurrent writes and achieving up to 200,000 writes per second in certain scenarios. While the experimental feature shows significant performance improvements over standard SQLite, it currently faces challenges with memory usage for frequently updated tables and writer contention on multi-core systems.