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

Tenets of Engineering

Big Idea I am getting to the stage of my career now where I have started picking up guiding principles that guide my socio-technical endeavors. I am sure I will continue to learn more and add them here or come back revise these with more wisdom and insight but what I want to start here is a collection of tenets. These tenets are not implementation details or design patterns but are more like paradigms for how we relate to problems, the natural systems that emerge from people thrown into teams, and more....

February 6, 2025 · 2 min