---
title: "Discussion on \"Designing SQL databases for rock solid data quality\" | Hashnode"
description: "Discussion on \"Designing SQL databases for rock solid data quality\". The blog focuses on 3 things,\n\nPrevention from data redundancy.\nGood design choices.\nBad design choices.\n\nPrerequisites: Basic knowledge of databases and practices like indexing, normalization, etc. \n\n1. Unique partial index to avoid data duplication..."
url: "https://hashnode.com/posts/designing-sql-databases-for-rock-solid-data-quality/65a3fb65400115ca928ef28e"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Designing SQL databases for rock solid data quality](https://blog.dumbbellcode.in/designing-sql-databases-for-rock-solid-data-quality?utm_source=hashnode&utm_medium=feed)

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...

Oct 2, 2022 · 5 min read · blog.dumbbellcode.in  
Read the article

## Written by

[Sudheer Tripathi](https://hashnode.com/@dumbbellcode)

@dumbbellcode · Mumbai, India.

  
[View profile](https://hashnode.com/@dumbbellcode)

Product-minded engineer | Backend, infra and AI | Ship or die

Product-minded senior engineer who saves teams time and money by steering product toward what's actually feasible. I've built AI code reviews in CI, data QC tools, automated PowerPoint reporting, caching microservices, resilient queues and high-volume Excel processing in Node. I've also made DB tests 4x faster, designed SQL schemas for data quality, rolled out distributed tracing, hardened AWS and built a centralised CI/CD system for 10+ repos. On the side, I've built a food safety AI for India, an AI-based form-filling extension, real-time apps and a lot of fun side projects.

## Responses 1

Markdown supported · ⌘↵ to post

[Mustansir Zia](https://hashnode.com/@mustansir)

[Jun 3, 2024](https://hashnode.com/posts/designing-sql-databases-for-rock-solid-data-quality/65a3fb65400115ca928ef28e/comment/665d60990bd7e83589d317d1)

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.