I already made the database, it's the one powering the Song Fight Jukebox.
For what it's worth, I've got a Google Doc with the complete set of instructions for how to update everything. I've also built tools to automate a bunch of the work. If we ever decide to enlist the aid of another fightmaster or two I hope they'll be able to hit the ground running.
Some parts of the process already involved Web forms before I got involved so those were already simple and easy.
The email submission part caused me the most manual labor so I use a script now to download all the emails and their attachments and do some automatic formatting of the file names to make them conform as much as possible. I don't want to encourage people to submit updated versions of their songs as being forced to be done and stop your work is part of the whole exercise. That being said, it does happen, so the script does some things to make that cause me less (but not zero) additional work.
There are a bunch of little steps around doing some setup on the FTP server and handling the art files, and I've got a script for all that now too. I just pick the art I want to use, copy a portion of its filename into a config file, and run that.
There are also a couple of magic text files with very specific formats which have to be created every time. I set up admin pages on the Jukebox which have forms that I fill out that (with things like date pickers for dates, autocomplete when entering band names to populate names of returning bands, automate selection of the fights for the five/ten/fifteen years ago sections, etc.) that generate the properly formatted text for me to copy/paste into the files.
I could probably go farther with some of that stuff and do some more programmatic interaction with the FTP server. Honestly though it's been a while since I've had the right mix of free time and motivation to continue on with that.
Personally I dream of a songfight.org where folks can listen to the current fight while also writing reviews on the same scree, navigate around the archive and look at artist profiles while the music keeps playing uninterrupted, bookmark songs/artists/fights they like, make playlists, etc. You know, something written in 2012 instead of something written in 2002.
