Archive for the 'Database' Category

Database, SQL

Sort Data with NULLs at the Bottom in Microsoft SQL Server

One of my clients has a reporting system that orders the data by a column that is a date. They wanted the sort to be ascending, but this places columns with a NULL value at the top followed by the data ascending. They wanted the NULL dates to appear at the bottom. To achieve this, […]

Database, PHP, Programming

Is Database Abstraction Really Worth The Hassle?

I’ve been building web apps for a long time now, I guess about 5 years. In the early days, database abstraction didn’t “exist”. Everyone just used the functions provided in the standard PHP library such as mysql_connect, mysql_query, etc. At some point, we as developers decided this wasn’t good enough. We needed an easier and […]