Soft deletion probably isn't worth it

Re:Soft deletion probably isn't worth it by vlunkr on Tuesday July 19, 2022 @03:26PM (#32156700)

That doesn't solve the foreign key problem. You can still easily have a reference to a record that is "deleted"

[ Parent | on HN ]

Re:Soft deletion probably isn't worth it by yen223 on Tuesday July 19, 2022 @06:00PM (#32158538)

Also in Postgres, you cannot have a foreign key constraint that references a view, not even a materialised view.

I'm with the author on this one. Any soft delete logic does have a tendency to bleed into other systems and make your systems more complicated, for very little gain.

[ Parent | on HN ]