Why Unique Indexes Matter More Than Application Validation (Backed by a Real Race Condition Demo)

When we build a signup or registration flow, the first thing most of us write is: