Home / Companies / Turso / Blog / Post Details
Content Deep Dive

SQLite Concurrent Writes Are Here: Early Preview on Turso Cloud

Blog post from Turso

Post Details
Company
Date Published
Author
Glauber Costa
Word Count
1,217
Company Posts That Month
1
Language
English
Hacker News Points
-
Post removed?
No
Summary

Turso Cloud has introduced early access to concurrent writes, overcoming a traditional limitation of SQLite by allowing multiple transactions to proceed in parallel with the use of the BEGIN CONCURRENT command. Unlike the traditional SQLite model that locks during write transactions, Turso employs a multi-version concurrency control (MVCC) engine, allowing several writers to operate optimistically without immediate locking, thereby increasing throughput and reducing the need for backoff-and-retry loops. Conflicts are detected at the row level during commit, which minimizes false conflicts and enhances efficiency when transactions touch different rows. This development is part of Turso's larger effort to provide a high-performance, cost-effective database solution, particularly appealing for developers looking for scalable and reliable options. Turso's approach draws on the principles of Microsoft's Hekaton engine, adapting them to work seamlessly with SQLite's B-tree storage. The feature is available for early preview, and users must enable it in their Turso dashboard, utilizing either the CLI or the dashboard UI to create a Turso database for concurrent transactions.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.