Why not name your database "my_db_all" and then create a view called "my_db" tha... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		Sohcahtoa82 on Jan 10, 2024 \| parent \| context \| favorite \| on: Soft Deletion Probably Isn't Worth It (2022) Why not name your database "my_db_all" and then create a view called "my_db" that's just "select * from my_db_all where deleted != true", or something to that effect?

waych on Jan 10, 2024 [–]

This seems to ignore the issues raised concerning foreign keys and consumer data protection pruning.

icedchai on Jan 10, 2024 | [–]

Just because a row is soft-deleted now doesn't mean it can't be actually deleted later.

waych on Jan 11, 2024 | | [–]

This is still ignoring the issues listed in TFA?

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact