The Soft Delete Trap: Why Your is_deleted Flag Is Quietly Destroying Your Database
Soft delete seems like the safe choice, but it introduces hidden costs around constraints, queries, foreign keys, compliance, and restore logic that can cripple your system.
