OXYGENHUB

Changes up to # 97b18869acf5 touching crates/hub/src/db/notify.rs · 6

See as swimlanes (independent work side by side)

Postgres, step 2c: inbox threads by window functions, RETURNING, lower() head
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 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