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 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…