Articles about

Databases

NULLification

2008-01-19 00:00:00 — 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.

Database Testing with PHPUnit and MySQL

2010-01-04 00:00:00 — I recently made a contribution to the PHPUnit project that I thought I'd take a blog post to discuss.

Customizing Codeception Database Cleanup

2014-05-09 00:00:00 — Recently, I was looking into ways to speed up the runtime of the test suite at Blopboard...

PHP 5.2 and SQL Server 2000 on Windows XP

2008-03-14 00:00:00 — 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

2008-11-05 00:00:00 — I ran into an instance recently where I wanted to implement natural sorting of a result set in MySQL.

Automating Personal Finance Monitoring, Part 2

2021-05-30 00:00:00