---
title: "#databasedesign articles | Hashnode"
description: "Explore 8 articles tagged #databasedesign on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/databasedesign"
---

Tag

# #databasedesign

8 posts · 1 followers

[Doogal Simpson](https://hashnode.com/@doogal) · [Nov 10](https://hashnode.com/posts/why-sql-unique-constraints-allow-duplicate-nulls/6af34e6af60522234a475d0f)

### [Why SQL UNIQUE Constraints Allow Duplicate NULLs](https://doogal.dev/why-sql-unique-constraints-allow-duplicate-nulls?utm_source=hashnode&utm_medium=feed)

Understand why SQL unique constraints permit duplicate NULLs, the impact on composite keys, and how to use NULLS NOT DISTINCT in PostgreSQL.

5 min read · [doogal.dev](https://doogal.dev/why-sql-unique-constraints-allow-duplicate-nulls?utm_source=hashnode&utm_medium=feed)

[3](https://hashnode.com/posts/why-sql-unique-constraints-allow-duplicate-nulls/6af34e6af60522234a475d0f)

[Daniel Anthony Romitelli Jr](https://hashnode.com/@romiteld) · [Aug 3](https://hashnode.com/posts/provenance-belongs-in-the-image-table/6a7106cc3366f9f4bfac0a7f)

### [Provenance Belongs in the Image Table](https://craftedbydaniel.hashnode.dev/provenance-belongs-in-the-image-table?utm_source=hashnode&utm_medium=feed)

A generated image looks finished until review starts. Someone approves the first version. Someone else crops it. A branded copy goes out. Another edit changes the prompt. A week later, the useful ques

7 min read · [craftedbydaniel.hashnode.dev](https://craftedbydaniel.hashnode.dev/provenance-belongs-in-the-image-table?utm_source=hashnode&utm_medium=feed)

[Doogal Simpson](https://hashnode.com/@doogal) · [Jun 26](https://hashnode.com/posts/storing-currency-exchange-rates-transactions-mqv6hslr/6a3eb07e6b3adb1583c59c24)

### [Storing Exchange Rates for Multi-Currency Systems](https://doogal.dev/storing-currency-exchange-rates-transactions-mqv6hslr?utm_source=hashnode&utm_medium=feed)

Avoid inaccurate revenue analytics in e-commerce systems. Learn why you must store historical currency exchange rates directly on transaction records.

4 min read · [doogal.dev](https://doogal.dev/storing-currency-exchange-rates-transactions-mqv6hslr?utm_source=hashnode&utm_medium=feed)

[varun](https://hashnode.com/@varun08) · [Jan 24](https://hashnode.com/posts/database-anomalies-explained-for-developers-who-think-queries-are-enough/6974feae038bf7491f73a8a7)

### [Database Anomalies Explained (For Developers Who Think Queries Are Enough)](https://killersofdatabase.hashnode.dev/database-anomalies-explained-for-developers-who-think-queries-are-enough?utm_source=hashnode&utm_medium=feed)

Learn about database anomalies in schema design, their impact on large scale like systems, and how normalization can effectively resolve them

4 min read · [killersofdatabase.hashnode.dev](https://killersofdatabase.hashnode.dev/database-anomalies-explained-for-developers-who-think-queries-are-enough?utm_source=hashnode&utm_medium=feed)

[Vaishnavi](https://hashnode.com/@vaishnavi9) · [Dec 18, 2025](https://hashnode.com/posts/why-data-gets-overwritten-a-beginners-guide-to-database-design-for-ingestion-systems/694465de55beab34e7e9ff99)

### [Why Data Gets Overwritten: A Beginner’s Guide to Database Design for Ingestion Systems](https://govidivenivici.com/why-data-gets-overwritten-a-beginners-guide-to-database-design-for-ingestion-systems?utm_source=hashnode&utm_medium=feed)

Learn why data gets overwritten in real systems and how good database design prevents it. A beginner-friendly guide with simple examples.

3 min read · [govidivenivici.com](https://govidivenivici.com/why-data-gets-overwritten-a-beginners-guide-to-database-design-for-ingestion-systems?utm_source=hashnode&utm_medium=feed)

[Debjit Sanyal](https://hashnode.com/@DebjitSanyal) · [Jun 27, 2025](https://hashnode.com/posts/materialized-view-pattern-vs-relational-materialized-views-a-comparative-analysis/685e166bbe52e199b666c45b)

### [Materialized View Pattern vs Relational Materialized Views: A Comparative Analysis](https://debjitsanyal.hashnode.dev/materialized-view-pattern-vs-relational-materialized-views-a-comparative-analysis?utm_source=hashnode&utm_medium=feed)

Materialized View Pattern (Software Architecture) The Materialized View Pattern in software architecture involves precomputing and storing query-specific views of data from one or more sources. It is often used in microservices or CQRS designs to opt...

6 min read · [debjitsanyal.hashnode.dev](https://debjitsanyal.hashnode.dev/materialized-view-pattern-vs-relational-materialized-views-a-comparative-analysis?utm_source=hashnode&utm_medium=feed)

[prakhar singh rajawat](https://hashnode.com/@NormadicDBA) · [Nov 4, 2024](https://hashnode.com/posts/introduction-to-dimensional-modelling/672885bc4fa70fcbbcea1f20)

### [Introduction to Dimensional Modelling.](https://normadicdba.hashnode.dev/introduction-to-dimensional-modelling?utm_source=hashnode&utm_medium=feed)

Dimensional Data Modelling which is a Data Modelling technique used for processing and Storing Data which is analyzed and queried for Reporting purposes.

4 min read · [normadicdba.hashnode.dev](https://normadicdba.hashnode.dev/introduction-to-dimensional-modelling?utm_source=hashnode&utm_medium=feed)

[Sanjay Rai](https://hashnode.com/@Sanjhok) · [Aug 21, 2024](https://hashnode.com/posts/choosing-the-right-database-for-your-product-key-technical-and-non-technical-considerations/66c60acc8c4c15720ab28513)

### [Choosing the Right Database for Your Product: Key Technical and Non-Technical Considerations](https://sanjhiar2133.hashnode.dev/choosing-the-right-database-for-your-product-key-technical-and-non-technical-considerations?utm_source=hashnode&utm_medium=feed)

When selecting a database for your product, it's crucial to evaluate both technical and non-technical criteria. The right choice can significantly impact your system's performance, scalability, and maintainability. Here’s a comprehensive guide to hel...

3 min read · [sanjhiar2133.hashnode.dev](https://sanjhiar2133.hashnode.dev/choosing-the-right-database-for-your-product-key-technical-and-non-technical-considerations?utm_source=hashnode&utm_medium=feed)

[Ian Carson](https://hashnode.com/@Carson001) · [Dec 4, 2023](https://hashnode.com/posts/why-uber-created-their-schemaless-db-and-why-you-should-too/656e07308c4ccf3f2de614e5)

### [Why Uber created their Schemaless DB and Why you should too.](https://iankiprono.com/why-uber-created-their-schemaless-db-and-why-you-should-too?utm_source=hashnode&utm_medium=feed)

Schemaless, Database, Uber, Database Scalability,Buffered Writes, idempotency

2 min read · [iankiprono.com](https://iankiprono.com/why-uber-created-their-schemaless-db-and-why-you-should-too?utm_source=hashnode&utm_medium=feed)

[Shiladitya Mukerji](https://hashnode.com/@ShiladityaMukerji) · [May 11, 2023](https://hashnode.com/posts/mastering-sql-server-query-optimization-key-concepts-terms-and-tips-for-lightning-fast-performance/645c8f4f8cfd606560efb515)

### [Mastering SQL Server Query Optimization: Key Concepts, Terms, and Tips for Lightning-Fast Performance](https://shiladitya-mukerji.hashnode.dev/mastering-sql-server-query-optimization-key-concepts-terms-and-tips-for-lightning-fast-performance?utm_source=hashnode&utm_medium=feed)

Introduction Are your SQL Server queries running slowly? Don't worry, you're not alone. Performance issues are a common problem that developers face when working with SQL Server. Fortunately, there are several quick and easy tips you can use to optim...

7 min read · [shiladitya-mukerji.hashnode.dev](https://shiladitya-mukerji.hashnode.dev/mastering-sql-server-query-optimization-key-concepts-terms-and-tips-for-lightning-fast-performance?utm_source=hashnode&utm_medium=feed)
