DDoogal Simpson·Nov 10Why SQL UNIQUE Constraints Allow Duplicate NULLsUnderstand 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.dev73OS
DDaniel Anthony Romitelli Jr·Aug 3Provenance Belongs in the Image TableA 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 ques7 min read·craftedbydaniel.hashnode.dev
DDoogal Simpson·Jun 26Storing Exchange Rates for Multi-Currency SystemsAvoid 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
Vvarun·Jan 24Database Anomalies Explained (For Developers Who Think Queries Are Enough)Learn about database anomalies in schema design, their impact on large scale like systems, and how normalization can effectively resolve them4 min read·killersofdatabase.hashnode.dev
VVaishnavi·Dec 18, 2025Why Data Gets Overwritten: A Beginner’s Guide to Database Design for Ingestion SystemsLearn 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
DDebjit Sanyal·Jun 27, 2025Materialized View Pattern vs Relational Materialized Views: A Comparative AnalysisMaterialized 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
Pprakhar singh rajawat·Nov 4, 2024Introduction to Dimensional Modelling.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
SSanjay Rai·Aug 21, 2024Choosing the Right Database for Your Product: Key Technical and Non-Technical ConsiderationsWhen 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
IIan Carson·Dec 4, 2023Why Uber created their Schemaless DB and Why you should too.Schemaless, Database, Uber, Database Scalability,Buffered Writes, idempotency2 min read·iankiprono.com
SShiladitya Mukerji·May 11, 2023Mastering SQL Server Query Optimization: Key Concepts, Terms, and Tips for Lightning-Fast PerformanceIntroduction 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