David Edgar's website

Saturday, 19 October 2024

🔖 Database Fundamentals

High level summary of the concepts discussed in Database Internals by Alex Petrov and Designing Data-Intensive Applications by Martin Kleppmann

🔖 Building BerkleyDb

Incomplete walkthrough on building your own database

🔖 How Postgres stores data on disk – this one's a page turner

Come for the pun in the title, stay for the look at how database systems structure data on disks.

🔖 SQLToy

A walkthrough for building your own database

🔖 BTrees and Database Indexes

Primer on BTrees and how they are used in database indexing

Friday, 11 February 2022

🔖 How Postgres Stores Rows