Re:Avoiding the soft delete anti-pattern
by minimeme on Sunday May 12, 2024 @03:34PM
(#40336901)
But what about data overwrites? This is basically the same as deleting data, since information will be destroyed. Using soft delete is a somewhat naive solution if there is no mechanism for restoring overwritten data.
[ Parent
| on HN ]
Re:Avoiding the soft delete anti-pattern
by throwaway894345 on Sunday May 12, 2024 @03:38PM
(#40336932)
Append-only tables are my preference. If you're worried about infinitely growing space, you can have some garbage collector clean up the least relevant records periodically for very little cost.