Introducing Real-Time Data with Materialized Views in Turso

Turso has unveiled an experimental feature called Live Materialized Views, which enhances SQLite by supporting real-time data processing through Incremental View Maintenance (IVM) and the DBSP framework, allowing data to remain up-to-date as base tables change. Unlike traditional Materialized Views that require expensive recomputation, Live Materialized Views efficiently update based on the size of changes rather than the size of the entire dataset, making Turso suitable for streaming and real-time systems. This innovation ensures transactional guarantees at the same isolation level as other database operations, allowing updates to be seen within transactions and rolled back as required. Turso's implementation includes operators such as Join, Filter, Aggregate, and Merge, although some features like recursive CTEs are still under development, and the on-disk format of Materialized Views is not yet stable, indicating that they are not ready for production use.