Skip to main content

Module query

Module query 

Source
Expand description

SQL query builders for SQLite backend with MVCC versioning.

The table schema uses (key, version) composite primary key:

CREATE TABLE IF NOT EXISTS "{table_name}" (
    key BLOB NOT NULL,
    version BLOB NOT NULL,
    value BLOB,
    PRIMARY KEY (key, version)
) WITHOUT ROWID;