@tuananh8

Reasons Your Unique Constraint Is Not a Complete Concurrency Strategy

9h ago · 11 min read · Source: Reasons Your Unique Constraint Is Not a Complete Concurrency Strategy You shipped a system where a unique index guards a business invariant. For a while everything looked fine: a unique constraint rejected duplicates, your logs showed an oc...

When NOT IN Becomes Slow and Why NOT EXISTS Is Often the Better SQL Rewrite

Mar 26 · 14 min read · Source: When NOT IN Becomes Slow and Why NOT EXISTS Is Often the Better SQL Rewrite 1. Why NOT IN Looks Simple but Becomes Expensive The reason many developers write NOT IN first is obvious: it reads like English. If I want customers who never...

When to Use Partitioning

Mar 25 · 14 min read · Source: When to Use Partitioning 1. The real question is not “what is partitioning,” but “what pain am I trying to remove?” Most teams do not wake up one morning and suddenly need partitioning because the word sounds advanced. They arrive ther...

Methods to Design Massive Log Tables (10–100GB/Day): Best Practices That Actually Scale

Mar 24 · 16 min read · Source: Methods to Design Massive Log Tables (10–100GB/Day): Best Practices That Actually Scale 1. The first best practice is to stop thinking in rows and start thinking in data lifecycle A huge log table is not just a table. It is a stream wi...

Methods to Know Exactly When to Use Strategy, Factory, and Builder in Java

Mar 23 · 16 min read · Source: Methods to Know Exactly When to Use Strategy, Factory, and Builder in Java 1. Why developers confuse Strategy, Factory, and Builder The confusion happens because all three patterns add indirection. At a quick glance, they can all appea...