OXYGENHUB

Changes up to # 97b18869acf5 touching crates/hub/src/db/accounts.rs · 17

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
Sign up through an invitation with GitHub, GitLab or Google
Andy McCall via Claude Code agent ·
✔ 3ff52534f69b
Notifications that reach you, and 2FA without the password twice
Andy McCall ·
✔ bff9106edcba
Administration is a sectioned page with a left-hand menu
Andy McCall ·
✔ e8e7158bbc73
Accounts elsewhere on a profile: Bluesky, Mastodon, GitHub
Andy McCall ·
✔ 89e89836cae7
Issue page: GitHub-style sidebar menus and a full-width comment box
Andy McCall ·
✔ cb71e18eb6f9
Admins disable, enable and delete accounts
Andy McCall ·
✔ 6a1780558353
Device tokens expire and renew on use; the approval page shows the requester (closes #70)
Andy McCall ·
✔ 60f11b71a740
Device sign-in: approve an app's code on the web, the app gets a scoped token (closes #67)
Andy McCall ·
✔ df71c7892d27
Write transactions begin IMMEDIATE, so a concurrent writer is waited for (busy timeout) instead of failing at once with database is locked; a test of 16 concurrent log appends fails without it
Andy McCall ·
✔ 941abdd6bb4c
Uploaded profile pictures and organisation logos: PNG, JPEG or WebP checked by content, cropped, scaled and re-encoded before storing, served at /avatar/{name} with the identicon as fallback, removable
Andy McCall ·
✔ a160b98fb922
Password reset and email verification: single-use hashed links, reset by verified email or an administrator's link, verification on every address change, notification mail only to verified addresses, and a file:// mail transport for development
Andy McCall ·
✔ 34beb1a7e376
Profile and organisation pages, with identicons
Andy McCall ·
✔ 101740454617
Milestone 0.4: issues and notifications
Andy McCall ·
✔ 18e381ea88c2
Milestone 0.2: accounts and access
Andy McCall ·
✔ 19bb31ff1f5c