Soft Deletion Probably Isn't Worth It
Anyone who’s seen a couple different production database environments is likely familiar with the “soft deletion” pattern – instead of deleting data directly via
DELETE
statement, tables get an extradeleted_at
timestamp and deletion is performed with an update statement instead.