THE DAY SOFT DELETES CAUSED CHAOS
Soft deletes in databases, while seemingly convenient, can lead to unfortunate consequences due to their hidden complexity and potential for data integrity issues. This author recounts a severe incident where a change in soft delete handling during a migration resulted in allowing the selling of the same seat an unlimited number of times for a popular concert. It’s worth considering using history/audit tables for preserving deleted data instead of soft deletes in production systems.