Comment by salomonk_mur

12 hours ago

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

Storage is cheap. Never delete data.

5 comments

salomonk_mur

Reply
ziml77  12 hours ago

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)

yxhuvud  8 hours ago

Deleting data is also a very easy way to not get GDPR compliance issues. Data is a cost and a risk, and should be minimised to what is actually relevant. Storage is the least part of the cost.

  • phito  7 hours ago

    Not an issue if you're not building SaaS

    • yxhuvud  1 hour ago

      Depends on your jurisdiction I suppose. If you are in EU it's a question if you have PII or not - if you are a SaaS or not is totally irrelevant.

sfn42  4 hours ago

Depends on the data in question. Some data is worth keeping, other data isn't.