Comment on Avoiding the soft delete anti-patternparentComments−mrkeen2yCan't get much more explicit than thatIf you want to preserve history (not just the special case of deletion) you'd also need to move 'updated' entities as well.The article isn't just pointing out that a 'deleted' column is a hassle, it's also pointing out it's insufficient for preserving history.−afiori2yThese options are ways to preserve entities not histories.For example you might not care to record the 20 different names/birthdays a user changed but you might care to remember that the user existed.
Comments
If you want to preserve history (not just the special case of deletion) you'd also need to move 'updated' entities as well.
The article isn't just pointing out that a 'deleted' column is a hassle, it's also pointing out it's insufficient for preserving history.
These options are ways to preserve entities not histories.
For example you might not care to record the 20 different names/birthdays a user changed but you might care to remember that the user existed.