mvcc

What problem does it solve?

MVCC provides snapshot isolation and per-transaction versioning to prevent readers and writers from blocking each other, enabling concurrent access with consistent views.

Core Features & Use Cases

• Snapshot isolation with multi-version data
• Per-connection mv_tx tracking for active transactions
• Version history and compatibility with SQLite-like workloads
• Use cases: long-running analytics, concurrent transactions, consistent reads during writes

Quick Start

Enable MVCC mode in the database with PRAGMA journal_mode = 'experimental_mvcc'; then begin an MVCC transaction and perform reads/writes within that snapshot context.