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

Turso v0.6.0

Blog post from Turso

Post Details
Company
Date Published
Author
Pekka Enberg
Word Count
3,039
Language
English
Hacker News Points
-
Summary

Turso 0.6.0 is a significant release that introduces comprehensive support for major SQLite features, such as multi-process access, vacuum operations, and generated columns, alongside improvements in SQLite compatibility, bug fixes, and performance enhancements. The update includes experimental multi-process support, enabling simultaneous database access, and introduces vacuum features for database file optimization. It also brings triggers, temporary tables, and generated columns out of the experimental phase, enhances the type system with arrays, structs, unions, and domains, and adds new SQL functionalities like CROSS JOIN, UPDATE FROM, and support for ROW_NUMBER() as a window function. Encryption for MVCC databases is now fully supported, and Turso's CLI becomes available on npm, allowing easy access to the Turso shell. With contributions from over 70 contributors, the release also includes new SDK features for JavaScript, Python, and Rust, catering to a wide range of database management and application development needs.