Two shoppers add the last pair of headphones to their carts. Both checkouts read available = 1 before either writes anything. If both accept the order based on that read, one customer gets a confirmation for stock you don’t have. Inventory reservation database design...
A team deletes a project called launch-plan, creates another project with the same name, and later restores the original. Which project gets the URL? Adding deleted_at to a table does not answer that question. Soft delete database design must define identity,...
How to Design a Database for External Data Imports Without Losing Identity A company imports customer records from three systems. The CRM contains [email protected]. The billing platform contains [email protected]. An older marketplace export contains the same...
Why Historical Records Need Snapshots, Not Live References A customer places an order on Monday. On Friday, they update their delivery address. Nothing unusual has happened. Yet when support opens Monday’s order, the system now shows Friday’s address. The database is...
How to Model Approval Workflows in a Database Without Boolean Chaos A supplier application has been approved. Then its bank details change. Is the supplier still approved? The answer sounds like a business-policy question, but it quickly becomes a database design...
Recent Comments