Troubleshooting Corruption in InnoDB

(apologies for the raw dump, keeping this for myself for posterity) Error: (intermittently) Warning: mysqli_connect(): (HY000/2002): No such file or directory in {} on line # Suspicions: – MySQL hitting a resource or connection limit – MySQL has a configuration error – Corrupt hardware/disk/partition/blocks – MySQL has corrupt data Checks: Read more…

A Fitness Data Project

Big surprise here: even in the gym I’m nerding out hard… I’m in the middle of writing a more thorough post on the habits and health hacks I’ve developed to go from a 270 lb couch potato to a … more in shape version of myself, but in the meantime Read more…

Factory Patterns in PHP and Python

Factory patterns allow you to call different codebases dynamically. Layered with a common interface a factory pattern is powerful for processing similar data returned from different APIs. I’ll add context later, maybe a factory pattern tutorial. But for now just saving the crux of implementations I’ve done in PHP and Read more…

A Single File PHP ORM

In most frameworks, ORMs like say… Eloquent, do a fair job extracting and abstracting the database into objects programmers use, but also generally come with a super steep learning curve. Back in 2014, I set out to create an abstraction that would turn MySQL tables and rows (relations and records Read more…

An Exercise In Recursion

Without the appropriate amount of caffeine or alcohol, “just do it recursively” can be a developer’s least favorite phrase. Don’t get me wrong, there is nothing more elegant than a well written recursive function. But when faced with a choice, most of us choose to add programming overhead and iterate Read more…