My First Database Refactoring

I spent a good portion of the day today refactoring the database used to power the Dave Matthews Band application I’ve been writing for Facebook.

I’ve been interested in writing for Facebook for some time because I believe that companies need to be expanding their online presence into applications built for major social networking platforms. It is easy to say that people should pay attention to things like OpenSocial or Facebook’s API, there have been plenty of articles about it. But nothing can convince you like building and running one yourself.

facebook application traffic statistics

My application began with only allowing users to choose a photo for their profile. Then I added the ability to select prior Dave Matthews Band shows. The problem came when people said they wanted to show their tour history further back than 2007.

I’ve been sourcing my data from the DMB Almanac, a site that I promote fairly heavily through the Weekly Davespeak’s front page and in the forums. I have a feeling I send them a good portion of traffic. Continue reading My First Database Refactoring