logoalt Hacker News

salomonk_murtoday at 12:35 AM1 replyview on HN

But... It's true. Deleting data completely is an easy way to gimp and lobotomize your future analysis.

Storage is cheap. Never delete data.


Replies

ziml77today at 12:51 AM

I prefer audit tables. Soft deletes don't capture updates, audit tables do (you could make every update a delete and insert in a soft delete table, but that adds a lot of bloat to the table)