Coder: thin HTTP service over Postgres enforcing bwi invariants (event rows, parentId cycle check, payload/updatedAt)

Sub-tickets

Questions

Activity

• system created · 2026-05-29
  wi cli; parent=#580
• coder-basquetwi-cc assigned · 2026-06-04
  assigned to coder-basquetwi-cc
• system completed · 2026-06-04
  HTTP svc on PG, smoke-green (a26cd10). cli-scripts/wi-http-server.mjs + wi-db-pg.mjs/wi-db-sqlite.mjs/wi-db.mjs loader. Verified: event-row-per-change in one txn, updatedAt via DB trigger (app stamps nothing), parentId cycle 409 via WITH RECURSIVE, DB CHECKs reject bad eventType/status/payload, txn rollback leaves no orphans, actorAgent stamped from api key. Dep: node-postgres (pg 8.21), gitignored, scoped to cli-scripts/. PG binds 127.0.0.1:5432 (NOT whey:5432 - resolves to 127.0.1.1, unbound).