News for hackers. Stuff that matters.

A comment on Soft deletion probably isn't worth it. Parent comment

Re:Soft deletion probably isn't worth it by smallnamespace on Tuesday July 19, 2022 @03:57PM (#32157107)
If you're using PostgreSQL, you can implement cascading soft-deletes yourself.

The information schema table holds all foreign key relationships, so one can write a generic procedure that cascades through the fkey graph to soft-delete rows in any related tables.

[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by BeefySwain on Tuesday July 19, 2022 @04:35PM (#32157597)
Could someone take a stab at an example of what this would look like? Sounds really interesting.
[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by NoInkling on Thursday July 21, 2022 @11:11AM (#32180340)
Here's an interesting approach using rules: https://evilmartians.com/chronicles/soft-deletion-with-postg...
[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by smallnamespace on Tuesday July 19, 2022 @10:55PM (#32160811)
Here's a toy implementation:

https://www.db-fiddle.com/f/n3ux4s7mcZ2554738T14QR/2

[ Parent | on HN ]