Want to create an interactive transcript for this episode?
Podcast: CodePen Radio
Episode: 383: Soft Delete All
Description: In this show, Stephen and Chris get to talk about an internal technical detail we were improving in our database, which led to a public-facing feature for y'all. The idea is that all (most, anyway) database tables should have a deleted_at column. When you query against them, under regular circumstances, any rows that have a non-null value will be filtered out. This is the concept of "soft" delete. It's not really gone from the database, it just behaves like it is. This has two clear benefits:
Deleting is super fast, it's just manipulating a single value.It...