Index Condition Pushdown Optimization in MySQL

Big Idea Getting under the hood of database implementations is starting to become an area of growing interest to me. Early in my career I was always content with SQL as an interface to 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 particular behaviour charatersitics in different circumstances. Further, I have never crossed-paths with a professional DBA and oftentimes feel left like there’s a whole sphere of mystery for me here....

June 2, 2025 · 2 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