Index Condition Pushdown Optimization in MySQL

Big Idea Getting under the hood of database implementations is becoming an area of growing interest for me. Early in my career, I was always content with SQL as an interface to a datastore that “just works.” That is, until it doesn’t anymore. It’s at those points that I am now being pushed to understand why a particular database implementation has certain behavioral characteristics in different circumstances. Further, I have never crossed paths with a professional DBA and often feel like there’s a whole sphere of mystery for me here....

June 2, 2025 · 4 min

Visual: URL Shortener

Big Idea I have been studying more systems desing more intentionally lately and this is the fruit of one evening of diagramming out a URL Shortner design. This post doesn’t explain much but a picture’s worth a thousand words!

January 13, 2025 · 1 min