Preparing the next view without exposing private workflow data.
Database engineering · Phased project
Make a database-backed work assignment queue correct
A fictional inspection service assigns review jobs to staff. Polling clients sometimes claim the same job and a disconnected client can finish work after reassignment.
Practice brief · Version 5
Project scope
10 tickets / 3 phases
Total focused work estimate
31h 45m + setup
Suggested stack
PostgreSQL · TypeScript
Recommended next step
Start with ACLAIM-101
Open the first ticket for its prerequisites, acceptance criteria, verification plan, and an editable task draft.
Practice database concurrency, leases and transactional invariants.
What the team gains
Review whether assignment authority remains reliable during contention and recovery.
Before you start
Create synthetic jobs and two independent database clients.
Use explicit state methods and an injected clock.
Delivery agreement
Ten scoped tickets across three phases. Build a synthetic local service or select a ticket after recreating its prerequisites; estimates exclude setup.
AI tools are welcome during implementation. Record assumptions, review the result, and verify its behavior.