pg: event store on Postgres, PocketBase removed #103

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

Port edastore (captures, mappings, bindings, binding_dispatches, playbook_dispatches, tool_calls) to goose migrations and sqlc queries in the same database; keep binding secret encryption (cipher.go) and the once-per-dispatch unique ledgers; keep the change notifications the dashboard relies on (LISTEN/NOTIFY is available). Remove PocketBase from edastore.

Notes

2ic ruling (approved): Before enforcing binding uniqueness during import/cutover, detect existing duplicates for one-per-source and one-armed-per-source rules. Do not auto-disarm or silently repair. Refuse the import atomically and report offending IDs so an operator can resolve them and retry; preserve the legacy source unchanged.

Close reason

Closed


Imported from beads archie-core-7r0x.3 · GitHub #1019 · type task · priority P1 · created 2026-09-23 · closed 2026-09-28

Port edastore (captures, mappings, bindings, binding_dispatches, playbook_dispatches, tool_calls) to goose migrations and sqlc queries in the same database; keep binding secret encryption (cipher.go) and the once-per-dispatch unique ledgers; keep the change notifications the dashboard relies on (LISTEN/NOTIFY is available). Remove PocketBase from edastore. ### Notes 2ic ruling (approved): Before enforcing binding uniqueness during import/cutover, detect existing duplicates for one-per-source and one-armed-per-source rules. Do not auto-disarm or silently repair. Refuse the import atomically and report offending IDs so an operator can resolve them and retry; preserve the legacy source unchanged. ### Close reason Closed --- _Imported from beads `archie-core-7r0x.3` · GitHub #1019 · type task · priority P1 · created 2026-09-23 · closed 2026-09-28_
sam added the hightask labels 2026-10-27 13:34:57 +00:00
sam self-assigned this 2026-10-27 13:34:57 +00:00
sam closed this issue 2026-10-27 13:34:57 +00:00
sam added a new dependency 2026-10-27 13:41:43 +00:00
sam added a new dependency 2026-10-27 13:41:43 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Reference: sam/archie#103