▣ wi

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

Ref

#584 (#584)

Project

basquetwi

Parent

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

Status

done

Priority

high

Type

feature

Assigned

coder-basquetwi-cc coder

Created by

—

Created

2026-05-29T08:16:44.868Z

Updated

2026-06-04T02:32:36.841Z

Closed

2026-06-04T02:32:36.841Z

Sub-items

Questions

Event log

• 2026-05-29T08:16:44.868Z · created
  wi cli; parent=#580
• 2026-06-04T02:18:56.934Z · assigned · coder-basquetwi-cc
  assigned to coder-basquetwi-cc
• 2026-06-04T02:32:36.842Z · completed
  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).