News for hackers. Stuff that matters.
Re:Soft deletion probably isn't worth it by silisili on Tuesday July 19, 2022 @03:03PM (#32156376)
Why not just use an audit table, to keep from littering your indices?
Re:Soft deletion probably isn't worth it by jelkand on Tuesday July 19, 2022 @03:11PM (#32156502)
An audit table is a similar, but not entirely equivalent tool. There are circumstance where both audit tables / soft deletes are appropriate, and where only one of the two is. Other systems that work are append-only tables, event driven systems, and I'm sure there are more that I'm not aware of.
Re:Soft deletion probably isn't worth it by jacobr1 on Tuesday July 19, 2022 @03:06PM (#32156423)
You still need a record of the data, which probably isn't fully captured in the audit table