While waiting for a few hundred megabytes of SQL statements to run... - 2006-01-23 00:14:09

I got one of these a week ago, which along with one of these which runs this upon which I installed a modified version of this (modified, means I fixed a couple of memory allocation bugs, replaced a double bubble sort with a call to qsort, and turned it into a daemon which listens on a network port and provides an interactive session for commands).

Tonight I finally got a chance to hack up small bit of code written in this using this, this, and this (via this).

So now I type the new DVD title into a web form and hit return. Then select the appropriate radio button for the matching imdb record, select the appropriate radio button for the matching cover image from amazon and click a button. Then wait a while, since the beast of a machine only has 32MB of RAM and is now doing XML processing, image manipulation, and parsing and executing SQL.

Once the wait is complete, I click another button and a free slot in the machine mentioned above opens into which I place the DVD.

Now I have a pretty web interface to my DVD "collection" (I didn't bother bringing my DVDs from Australia - so this is really overkill for the dozen DVDs I currently have) which shows imdb data with links to the imdb site for more data and links which cause DVDs to be ejected (or empty slots opened for them to be put back).

Trying out my pretty new interface also showed me that all but one of my DVDs are in the imdb genre "action" (and the odd one out is really Kian's). Half of them are "sci-fi" too. And I haven't bother putting my Firefly series DVDs in yet...

List All | Archives: 2002 2003 2004 2005 2006 2007 2008