Why SQL Exists
Data independence, declarative queries, and the rise of the relational model
Blog
Deep dive into database kernel internals
Inside DuckDB: Columnar Storage and Vectorized Execution
Unpacking DuckDB's core design — PAX columnar layout, vectorized execution engine, and Morsel-Driven parallelism
CMU 15-445: A Complete Learning Path for Database Systems
A structured guide to mastering Carnegie Mellon's legendary database systems course — prerequisites, modules, projects, and companion resources
MySQL InnoDB vs PostgreSQL: A Deep Comparison of MVCC Implementations
Contrasting how InnoDB and PostgreSQL implement MVCC — rollback segments vs in-heap versioning, trade-offs and best use cases
PostgreSQL Clock-sweep Algorithm: A Source Code Walkthrough
Deep dive into PostgreSQL's buffer replacement algorithm — how Clock-sweep works, why not LRU, and a line-by-line reading of bufmgr.c