Articles about

Databases

NULLification

January 19th, 2008 — I've seen some "interesting" things during my time with database systems, but the one that takes the cake by far is variations in how `NULL` is interpreted.

PHP 5.2 and SQL Server 2000 on Windows XP

March 14th, 2008 — Recently at work, I was tasked with finding a method to retrieve data from a third-party SQL Server 2000-based system into our own MySQL-based application.

Natural Ordering in MySQL

November 5th, 2008 — I ran into an instance recently where I wanted to implement natural sorting of a result set in MySQL.

Database Testing with PHPUnit and MySQL

January 4th, 2010 — I recently made a contribution to the PHPUnit project that I thought I'd take a blog post to discuss.

Customizing Codeception Database Cleanup

May 9th, 2014 — Recently, I was looking into ways to speed up the runtime of the test suite at Blopboard...

Automating Personal Finance Monitoring, Part 2

May 30th, 2021