Proudly hosting 37500 demos by 530 players on 2627 WADs for a total running time of 3129:15:50.
Greetings DooMers! Andy Olivera here. It's been a long time coming, but the new, improved DooMed Speed Demos Archive is finally here.
Some background: This redesign was born approximately two years ago when Opulent was feeling down. It occured to me that having all those demos piling up would make the updating process a daunting task: updating each of the over 900 WAD pages individually, moving the files to their proper locations, keeping the tables up to date with entries from the dormant(dead?) Compet-N. I came to the conclusion that the DSDA had grown too large for manual updating and a new approach was needed. Whether this new approach would be utilized by Opulent, myself or someone else, I didn't know. So, with my meager coding knowledge I set out to redesign the DSDA as a dynamic, database-generated website. I had no idea it would take so long!
The backend portion took around six months. My first instinct was to use phpMyAdmin, but for the amount of records I needed to enter, it was just too slow and bloated. The initial plan was to write a simple record entry script. Thankfully, as I was writing and learning a bit more about PHP, it evolved into an efficient system of record management and file handling. That evolution probably saved me from getting burned out and abandoning the project during the next step.
Next up was the task of entering all the existing demos into the database. This took nearly 18 months and was incredibly tedious. Third, and finally, came the designing of the actual website. This step was a picnic compared to the other two. Though it did contain a few hurdles and the site didn't arrive with all the superfluous features I'd planned, I'm satisfied with the way it's turned out and I think you will be, too.