HomeRamblings  ⁄  mysql

mysql

Ruby, Mysql, CentOS 5, and 64-bit

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 little to no 32-bit libraries installed.  There's been a few sticky points to push through and one of them is getting Mysql and the appropriate mysql gems installed.  This quick post shows the way. ## My System I am running CentOS 5.2 64-bit. Or more succinctly: ~~~ text 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 11:57:43 EST 2008 x86_64 x86_64 x86_64 GNU/Linux ~~~ ## The Problem If you simply execute: ~~~ bash sudo gem install mysql ~~~ You'll get the following errors on a 64-bit system:… read more


Geocoded Zipcodes

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 looking up zip codes and so on, there's not really any free data to be had that I could tell. So the hunt was on to find some zip code data, preferably geocoded (latitude/longitude for GIS) zip codes and then load them into MySQL. A bit of hunting around turned up [this list of zip code databases][1]. The first link to CivicSpace database appears to be defunct (I got a Go Daddy "this page is parked" page). So, the next free one, offered by [Popular Data][2]… read more