Content tagged with "databases" (5)

Why Buildkite moved its primary keys to UUIDv7, which keeps the global uniqueness of a UUID while staying time-ordered enough to sit well in a B-tree index.

Sizes a B-tree node to a disk page and walks the math from there, showing why the primary key you choose sets how many pages every query has to read.

Hash tables win the single-lookup benchmark, yet databases default to B-trees. The payoff is everything past that one lookup: range scans, sorted reads, and maintaining many indexes at once.

A point-by-point rebuttal of Uber's famous 'we left Postgres for MySQL' post, arguing the problems were specific to how they used it, not a verdict on the database.

Build a SQLite clone from scratch in C, and after that you'll never write a SELECT statement without knowing exactly what the machine is doing underneath.