Comment by zero_kool

I'm currently in the process of migrating back to hard-delete from soft-delete on my current company's codebase. We use a slightly different approach of using triggers to do cascade deletes. It's just very difficult to maintain as the product grows bigger. All those additional overhead to create additional rules for every table and the scope for human error. Overall, I dont recommend anyone take the route of soft-deletes unless it's absolutely required.