feat(gateway): version the SQLite session schema before cutover #611

Closed
opened 2026-10-27 13:37:01 +00:00 by sam · 0 comments
Owner

OpenSQLiteSessionStore currently runs CREATE IF NOT EXISTS statements with no schema version or transactional migration record. Before production wiring, add the smallest deterministic schema-version mechanism so future upgrades cannot silently leave a partially evolved database.

Acceptance Criteria

A fresh database records the current schema version; opening a supported older fixture migrates transactionally and preserves data; unsupported newer versions fail with an actionable error; migration failure leaves the prior schema/data usable; schema initialization and upgrades are covered by file-backed tests.


Imported from beads archie-core-1786637491986-84-5137df75 · GitHub #105 · type feature · priority P2 · created 2026-08-08 · closed 2026-08-09

OpenSQLiteSessionStore currently runs CREATE IF NOT EXISTS statements with no schema version or transactional migration record. Before production wiring, add the smallest deterministic schema-version mechanism so future upgrades cannot silently leave a partially evolved database. ### Acceptance Criteria A fresh database records the current schema version; opening a supported older fixture migrates transactionally and preserves data; unsupported newer versions fail with an actionable error; migration failure leaves the prior schema/data usable; schema initialization and upgrades are covered by file-backed tests. --- _Imported from beads `archie-core-1786637491986-84-5137df75` · GitHub #105 · type feature · priority P2 · created 2026-08-08 · closed 2026-08-09_
sam added the mediumfeature labels 2026-10-27 13:37:01 +00:00
sam self-assigned this 2026-10-27 13:37:01 +00:00
sam closed this issue 2026-10-27 13:37:01 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: sam/archie#611