News for hackers. Stuff that matters.
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.
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.