Avoiding the soft delete anti-pattern

Link: Avoiding the soft delete anti-pattern: "The main problem with soft deletion is that you’re systematically misleading the database. This is most obvious in the case of foreign key constraints."

I had never thought of this. It makes sense. Interesting.