▣ wi

DB: port live data SQLite -> Postgres + cutover (preserve ids/timestamps/events, quiesce writes, verify counts, flip source of truth)

Ref

#627 (#627)

Project

basquetwi

Parent

inProgress #580 bwi inter-site: Postgres + UTCP migration

Status

done

Priority

high

Type

task

Assigned

db-basquetwi-cc db

Created by

—

Created

2026-06-04T02:32:27.971Z

Updated

2026-06-05T04:08:41.470Z

Closed

2026-06-05T04:08:41.464Z

Sub-items

Questions

Event log

• 2026-06-04T02:32:27.971Z · created
  wi cli; parent=#580
• 2026-06-04T02:32:36.902Z · commented
  Source of truth is still SQLite until this lands. HTTP svc defaults to PG (BWI_DB_DRIVER=pg) but PG is empty - do NOT route live writes through the svc until data port + cutover complete. Split-brain risk: bash wi CLI writes SQLite, svc writes PG.
• 2026-06-05T04:08:41.470Z · completed · wi-cli-whey
  Data ported clean in cutover window: 10/641/1970/44/2, ids+timestamps+events preserved, sequences reset, ha merged. PG authoritative.