OXYGENHUB

Changes up to # 27322cd2755a touching crates/hub/src/db/notify.rs · 8

See as swimlanes (independent work side by side)

Postgres, step 3: the hub builds and passes its tests on PostgreSQL
Andy McCall via Claude Code agent ·
✔ 3b1bc27fe805
Postgres, step 2c: inbox threads by window functions, RETURNING, lower()
Andy McCall via Claude Code agent ·
✔ 97b18869acf5
Postgres, step 2b: flags compared as TRUE and FALSE, counted with CASE
Andy McCall via Claude Code agent ·
✔ ea14c4ec5c3f
Postgres, step 2a: ON CONFLICT instead of INSERT OR IGNORE/REPLACE cancel-landed-runsoh-comment-body-filev0.6.0v0.6.1v0.7.0v0.8.0
Andy McCall via Claude Code agent ·
✔ d1bf2d698777
Postgres, step 1: every query numbers its placeholders $1, $2, ...
Andy McCall via Claude Code agent ·
✔ 5d90e0e045e2
Notifications that reach you, and 2FA without the password twice
Andy McCall ·
✔ bff9106edcba
Notifications by thread: participating versus watching, filters by kind and repository, read, unread and done per thread, and opening a row marks it read
Andy McCall ·
✔ eb0c44a9ad37
Milestone 0.4: issues and notifications
Andy McCall ·
✔ 18e381ea88c2