Hacker News Reader

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.

View on HN

Could someone take a stab at an example of what this would look like? Sounds really interesting.

Here's a toy implementation:

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

Here's an interesting approach using rules: https://evilmartians.com/chronicles/soft-deletion-with-postg...

Reply on news.ycombinator.com