Databases

Databases & Data Engineering

A Schema That Models the Problem Well Is Worth More Than Any Query Tuning

The most impactful database decision is the schema itself, because a well-designed schema makes queries simple and fast, while a…

Read More »
Databases & Data Engineering

The Isolation Level You Choose Is a Promise About What Can Go Wrong

The default isolation level of most databases is not the strongest one, and choosing a level is choosing which concurrency…

Read More »
Databases & Data Engineering

A Backup You Have Never Restored Is a Hope, Not a Plan

The only way to know a backup actually works is to restore it, and a backup that has never been…

Read More »
System Design

Sharding Moves the Problem From One Big Database to Many Hard Decisions

Sharding spreads data across many databases to scale, but it moves the problem from one big database to a set…

Read More »
Back to top button