Justin's Blog

January 1, 2014

My Average Salary

I started a salary lookup database, because I got tired of the BLS website's interface and thought I could do one better.

Man, it was a pain in the butt!! 11 million rows, and I generated the sql to load them into my database with a Ruby script. That was after I generated the schema from phpMyAdmin and cut up the dump files. But that could only happen after I reverse engineered the sql schema from the tsv files provided by the BLS.

Anyway, check you can check it out here: My Average Salary

I would like to add cost-of-living data to it, but I'm stuck optimizing queries right now.

Back to the top