tutti/packages/connector/daemon/adapters/sqlite

Connector SQLite Store

packages/connector/daemon/application/adapters/sqlite is the canonical local SQLite implementation of the Connector Host repository and changed-event outbox contracts. Hosts own the selected database path and process lifecycle; the module owns schema, migration, transactions, revisions, leases, and operation persistence.

Device installation remains on the Connector row. Account authorization is stored independently in connector_market_authorization_projections, keyed by account_id + connector_key, so account switching cannot overwrite installed truth. Local uninstall deletes installed-release evidence but never deletes the account authorization Projection; disconnect is a separate authorization operation.

Authorization Session receipts remain private inside completed Start operation records. Snapshot application uses one SQLite transaction to advance the account Projection and surface every matching unresolved receipt when the server reports the Connector connected. Older Snapshot revisions never replace newer Projection state; the daemon resolves a receipt only after its scoped Runtime Reconcile completes.

Active operations and pending outbox events are durable and never age-pruned. The lifecycle cleanup contract removes bounded batches of expired terminal operations and already-published events. Installed release evidence is stored separately from operation history so runtime recovery does not depend on an expired operation row. A probe-detected missing implementation retains that evidence while installation is failed, allowing repair or uninstall to keep targeting the accepted release.