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

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