Constant SCHEMA 

const SCHEMA: &str = "
    CREATE TABLE IF NOT EXISTS commits (
        rev       INTEGER PRIMARY KEY,
        wall_time INTEGER NOT NULL,
        payload   BLOB NOT NULL
    );
";

Payloads are CBOR, the same bytes the wire carries (decided 2026-08-16). The cost, accepted with the decision: rows are opaque to sqlite3 and ripgrep, so “when did this route change” needs a tool that decodes rather than a grep.