Reliable Software
Use a Unique Database Constraint to Settle Competing Inserts
Prevent duplicate records under concurrent requests with a database uniqueness rule, while designing a useful application response to conflicts.
SOFTWARE · SECURITY · DESIGN
Reliable Software
Reliable Software
Design a Database Migration That Older App Versions Can Survive
Plan a database change around overlapping application versions, separating schema expansion, data backfill and removal of obsolete fields.
Reliable Software
A Retry Button Should Not Create a Second Order
Design retries around one intended operation so a timeout does not become a second order, with clear keys, state checks and provider-specific rules.