Turso v0.4.0
Blog post from Turso
Turso v0.4.0 introduces significant advancements to SQLite, featuring the implementation of MVCC for concurrent writes, improved sync capabilities, and performance enhancements such as hash joins and better query efficiency. The MVCC overhaul removes the single writer limitation by allowing multiple threads to write concurrently without locking the database, although it remains experimental and not recommended for production. New sync features, including partial sync, enable applications to access databases without downloading entirely, employing strategies for faster initial data access and latency reduction. This update also extends sync support to Python and Go SDKs, previously limited to JavaScript. Additional improvements include asynchronous API support in Python, enhanced handling of large queries via page cache spilling, and the integration of the ANALYZE command to optimize query plans. Overall, these updates promise better performance and flexibility for developers working with Turso and SQLite databases.