Turso v0.5.0

Turso v0.5.0 introduces several significant enhancements, including beta support for concurrent writes using multi-version concurrency control (MVCC), experimental full-text search powered by Tantivy, and notable improvements in the query optimizer. The release marks the stabilization of change data capture (CDC) and the introduction of user-defined types, allowing for the creation of custom data types beyond SQLite's native storage classes. The MVCC implementation now supports savepoints, enhanced conflict detection, and a lock-free rowid allocation mechanism, while the full-text search feature integrates seamlessly within the database file and offers configurable tokenizers and weights. Query optimization sees advancements with hash joins, semi/anti joins, and multi-index OR scans, alongside a refactored cost estimation model. Turso 0.5 also fully supports STRICT tables, ensuring strict column type constraints, and promotes CDC from unstable to stable status, adding a new record format for better change tracking. This release, featuring contributions from over 50 developers and more than 3,000 commits, also brings various other enhancements and compatibility fixes, with detailed documentation and support available on GitHub and Discord.