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?
[ Parent
| on HN ]
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.