Writing

Short essays, usually after building something.

Published on LinkedIn.

  • Sep 2026 : What ROWID actually is: slotted pages, PCTFREE and fillfactorWhy a database never reads a row, how a slot array gives rows a stable (page, slot) identity, why B-tree leaves can point at it, and how Oracle and PostgreSQL both end up advising you to leave free space in each page.
  • 2025 : Exploring PCA through image compressionA full PCA pipeline built by hand on 8×8 image blocks, with orthogonal iteration instead of a library eigen-solver, and the quality–compression trade-off visualised.
  • 2025 : Solving Ax = B with QR decompositionGram-Schmidt in Python with 3D plots of how a matrix splits into Q and R, and why QR is more stable than the normal equations for least squares.
  • 2024 : Olympic data analysisAthlete representation and medal counts by country, how team size correlates with medals, and events by sport.

What I write about

Mostly database internals, the kind of thing you only notice when you build it yourself: how pages are laid out, why indexes can point at rows safely, what an abstraction hides until you look under it. Also the linear algebra behind ML, implemented by hand rather than imported.

I'm planning a YouTube channel on the same material, explaining software engineering internals from first principles.