Advanced Unique Index Patterns for Soft Deletes (MySQL and PostgreSQL)

Tell me if this has ever happened to you: a user contacts support because they’re randomly seeing different order histories every time they log in. Sometimes they see their recent purchases, sometimes they see orders from years ago, and sometimes they see nothing at all. After several hours of debugging, you discover that […] The post Advanced Unique Index Patterns for Soft Deletes (MySQL and PostgreSQL) appeared first on PHP Architect.