Using PHP 5.3 with MSSQL PDO on Windows

Due to some legacy applications at the office, I occasionally find myself needing to connect to MSSQL through PHP for some various tasks. Unfortunately as of version 5.3, PHP stopped shipping with a default mechanism to connect to a MSSQL…

Geolocation: Getting Distance in Miles with PHP & MongoDB

Geolocation requirements are becoming very common with all the location based apps cropping up recently and MongoDB provides some great features to get up and running quickly. By default Mongo returns results in radians, in order to get the distance…

Creating useful MySQL indexes – InnoDB & MyISAM using B-Tree

Any database developer understands that indexing is extremely important for optimal query performance. Here we’ll attempt to get beyond adding one column per index to being more purposeful about intelligent index creation. In order to be able to efficiently index…