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...
Responses
Markdown supported · ⌘↵ to post
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.