Content tagged with "databases" (5)
All content across blogs, linklog, and books with this tag.
Links
- by Buildkite
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.
- by Ben Dicken
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.
- by Evan Jones
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.
- by Markus Winand
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.
- by Connor Stack
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.