Skip to content

v0.6.1 — the SQLite-switch patch

Latest

Choose a tag to compare

@Acfufu Acfufu released this 23 Oct 22:44
· 51 commits to main since this release

Highlights

  • Migration fixed on real-world ledgers (0.6.0 regression, found by
    dogfooding the migration on this repo's own ledger): ledgers whose
    budget events carry object-shaped provenance (the review-runner
    shape) crashed the import phase with
    Provided value cannot be bound to SQLite parameter 5, and the read
    side could never reconcile either. The TEXT-column convention is now
    unified with the append facade — objects/arrays stringify on write
    and restore on read; bare strings and "123"/"true"-style literals are
    untouched.
  • Named refusal for missing dedupKey at both budget-event write
    entry points (dedup_key is NOT NULL — the schema is the gate,
    replacing a cryptic bind error).
  • Plan-gate word-boundary fix: an identifier containing "tbd"
    (e.g. a random temp-dir suffix like vqlTbd) no longer false-flags
    plan adoption as an undecided marker.
  • Test/fixture isolation for the usage ledger:
    sandboxUsageDir() honors LZY_SANDBOX_USAGE_DIR (production
    default unchanged), and six test files now run isolated so fx.*
    fixtures stop writing rows and retry receipts into the real
    ~/.zcode/cli/lzy-usage.

Verification

966/966 tests; CI four legs green (node 24 × ubuntu/windows +
sqlite-floor + docs-links). win32 coverage via the CI windows leg — the
0.6.1 delta is platform-neutral JS; the 0.6.0 VM battery remains the
platform baseline.

Upgrade

lzy update (0.0.7+). Requires the ZCode desktop app (logged in),
Node ≥ 24 (raised in 0.6.0 — ADR-0039), and git. Workspaces on the
JSON backend keep working; migration to SQLite stays an explicit,
one-way lzy migrate sqlite <root>.