Designing SQL databases for rock solid data quality
The blog focuses on 3 things,
Prevention from data redundancy.
Good design choices.
Bad design choices.
Prerequisites: Basic knowledge of databases and practices like indexing, normalization, etc.
1. Unique partial index to avoid data duplication...
blog.dumbbellcode.in5 min read
Mustansir Zia
I write code for a living.
I personally loved the topic on partial indexes and how it solves the use case of uniqueness in case there are soft deleted rows. (Since every NULL is considered a unique value)
It is worth mentioning however, that partial indexes are not yet supported in every database engine including the one in the latest version of MySQL.