The challenges of soft delete
Summary
The article critiques the traditional archived_at approach for soft deletes and explores alternatives such as application-level archiving, database triggers, and WAL-based change data capture. It provides practical code samples, discusses tradeoffs, and ends with a recommended approach for clean live data with accessible archived data.