Soft delete pattern lets you mark records as deleted instead of physically removing them — enabling safe recovery, audit trails, and GDPR-compliant data retention. This guide covers practical implementation in PostgreSQL and MySQL, including partial indexes, unique constraint handling, and cleanup strategies.