02 Jul 2013
Sorting Children by Hierarchy with Closure Tables
Unfortunately, this was for a well-established project built on MySQL, so the recursion and Common Table Expressions of SQL Server or PostgreSQL weren't options.
03 May 2013
The Web Gets More Secure: SQLI Not the Biggest Hole in this Swiss Cheese
It's getting better, but...ouch.
18 Apr 2013
PHP DateTime Differences (Signed!)
Note to self: remember to add "%R" (or "%r") when formatting a date difference in PHP.
05 Apr 2013
PHP Property Visibilty
Of course I knew that private properties and methods are visible only to the class that defined them, but one particular implication of that fact had not yet crossed my mind.
28 Mar 2013
PyroCMS vs. mod_security
Upon clicking the last button on the last step of the installation, the whole thing fell apart.
23 Mar 2013
Conservative UX Design
An excellent principle of web design of which even Russell Kirk would approve.