How Databases Organize Data on Disk: Pages, Blocks, and File Formats

How Databases Organize Data on Disk: Pages, Blocks, and File Formats

How Query Engines Think: The Tradeoffs Behind Every Data System

The Mathematics of Data Structures: Why No Single Storage Solution Is Optimal

The article explores the fundamental trade-offs in data structure design, explaining that there's no single optimal way to store information

Rethinking Database Architecture for the SSD Era: Beyond Spinning Disk Constraints

The article explores how traditional relational databases (like Postgres, MySQL, SQLite) were designed for spinning disk era hardware and ex

Understanding B-Trees: The Data Structure That Powers Database Performance on Disk

The article explains why B-Trees are the fundamental data structure used in databases for disk-based storage. Through a personal narrative o

Partition and Organize Data for Performance