Category
6 articles in this category.
Written by me.
A data model is a set of decisions about what to store and how to retrieve it. Read the mechanism, a worked example, and why a diagram is not a design.
Indexes speed reads but cost storage and slow writes. Learn what index structures and query optimizers do, a worked trade-off, and when an index fails to pay.
Replication copies data across systems. Read the trade-offs, a worked setup, and why a replica can be correct and still be stale.
NoSQL trades joins for access patterns. Read the design method, a worked example, and why a distributed store forces explicit trade-offs.
A planner chooses how to run a query. Read how to work with it, a worked example, and why a hint is not a substitute for evidence.
An index is not a promise of speed. Read when the planner ignores it, how to read EXPLAIN, and the write cost you pay for every index.