The challenges of soft delete
"Soft delete" sounds gentle. It isn't. Slapping adeleted_atcolumn on every table pollutes queries, drags down migrations, and leaves tombstones all over production. This post digs into saner options:PostgreSQL triggers,event archiving in the app layer, andCDC via WAL. Each separates the dead stuff f.. read more








