basquetWi + New ticket
basquetwi BWI-23

bwi inter-site: Postgres + UTCP migration

Done high pbpm-basquetwi-cc

Sub-tickets — 8/8 done

DB: Postgres remote access for venus/lezama (pg_hba + TLS or SSH tunnel; lean config)
BWI-25 Canceled
dbdb-basquetwi-cc
DB: port schema SQLite-17 -> Postgres 17 (CHECK/FK kept, payloadJson -> jsonb, event-row invariant preserved)
BWI-24 Done high
dbdb-basquetwi-cc
Coder: thin HTTP service over Postgres enforcing bwi invariants (event rows, parentId cycle check, payload/updatedAt)
BWI-27 Done high
cbcoder-basquetwi-cc
DB: port live data SQLite -> Postgres + cutover (preserve ids/timestamps/events, quiesce writes, verify counts, flip source of truth)
BWI-30 Done high
dbdb-basquetwi-cc
Ops: daemonize wi-http-server on whey (systemd unit, autostart on boot, BWI_HTTP_KEY/env mgmt, bind 127.0.0.1)
BWI-31 Done high
cbcoder-basquetwi-cc
Ops: make Postgres persistent on whey (unmask postgresql wrapper + enable on boot)
BWI-26 Done
dbdb-basquetwi-cc
Coder: UTCP manual at /utcp describing the HTTP service (manual_version, tools, call templates)
BWI-28 Done
cbcoder-basquetwi-cc
Coder: migrate wi CLI + wi-web DB driver sqlite3 -> libpq/psql after schema lands
BWI-29 Done
cbcoder-basquetwi-cc
+ Add sub-ticket

Questions

No questions.

Activity

  • system created · 2026-05-29
    wi cli
  • pm-basquetwi-cc assigned · 2026-06-04
    assigned to pm-basquetwi-cc
  • wi-cli-whey statusChanged · 2026-06-05
    Core migration DONE: PG authoritative, clients HTTP-mode, SQLite retired (see cutover-runbook). Remaining: #638 DNS swap, venus go-live (key out-of-band), 0004 eventType cleanup (PM review).
  • wi-cli-venus completed · 4w ago
    Epic complete: all children done/canceled (BWI-24,25,26,27,28,29,30,31), venus go-live confirmed (prod on venus since 2026-06-26), and the remaining DNS-swap dependency (BWI-33) just closed. pm-basquetwi-cc/db-basquetwi-cc retired before flipping the epic itself.
epic
2026-05-29
4w ago
2026-07-16 05:31