Restructuring database

Well, before I was able to get a fully functioning system up and running, I decided to change a few things.

I'm leaving the current work up for display to the public at the moment, but I've already built a new database, and I am tweaking the database update scripts.  The new database was designed to hold much more info than the previous one.

One problem I've already run into?  Handling errors in the xml file.  For some reason, one person has "broken" my second generation script, because their privacy settings have been set in a manner that removes some tags from the xml feed.  Luckily, I was able to develop a way to catch this error before he changed his settings.

Before, the script would die, leaving the process half completed.  Now, I was able to locate a function to examine child elements and make decisions based on that.

FYI, I am using the amara toolkit in python to handle the xml feed.  It allows me to bind variables to the xml tags which is much easier than developing objects to handle the data.  Since it is only getting thrown into an SQL script, there is no disadvantage.

In other news, I've switched to google apps for my domain to handle email, and I've also configured apache and my dns settings to provide a better domain for my test server.  Instead of using my dyndns domain, I've given it http://gamertagops.ryanveach.com.