---
title: "Mustansir Zia (@mustansir) | Hashnode"
description: "I write code for a living. Read the latest articles by Mustansir Zia on Hashnode."
url: "https://hashnode.com/@mustansir"
---

@mustansir

# Mustansir Zia

@mustansir · Joined June 2024

I write code for a living.

## Comments

[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.](https://hashnode.com/posts/designing-sql-databases-for-rock-solid-data-quality/65a3fb65400115ca928ef28e/comment/665d60990bd7e83589d317d1)

Comment · Article · Jun 3, 2024 · [Designing SQL databases for rock solid data quality](https://hashnode.com/posts/designing-sql-databases-for-rock-solid-data-quality/65a3fb65400115ca928ef28e)