mysql

Ruby, Mysql, CentOS 5, and 64-bit

Posted by Michael on January 19, 2009 in SQL, Systems

I have lately switched away from Ubuntu as my desktop and started using CentOS 5.2 because I wanted better support for a lot of RAM and virtualization (where I can quickly commission Linux servers to build out my testbed of target environments).  With the change, I also make the leap into pure 64-bit libraries with [...]

Geocoded Zipcodes

Posted by Michael on July 7, 2008 in Ruby Language, SQL

You would think that loading up a database of zip codes would be an extremely simple case of finding a public database on www.usps.gov, and then loading up with a database bulk load. It turns out that, while the USPS does offer products for you to purchase, and a rather nice lookup interface for [...]