CD Database  #
Monday, 12 Apr 2010 12:43PM
I've had my own CD database for almost a decade now. It was built in spare moments out of ASP and SQL Server, later converted to mySQL to run at home on my WinXP Pro PC.

Last night I noticed that IIS wasn't working any more (Windows Integrated Security kept failing and Anonymous access user wouldn't work). I suspect it was caused by a security update of some kind. It forced me, finally, after much reinstalling and Googling, to dump IIS from my machine. I've never been comfortable running a web server on my home box anyway, even though I only turned it on when using the CD Database.

My first thought was to rewrite the application in .NET, using a free IDE like SharpDevelop. A few quick experiments shows this should be possible, but I don't want to put the effort in.

So I looked around at existing software for CD Databases and again found myself looking at Collectorz.com's software. I've always been put off by it because it's import is so basic. The best way to add CDs to it is to insert the CD physically into the drive, which I really didn't want to do... but as I'm going through all my CDs again anyway (don't ask) I figure it's the best time to get this.

So I'm going to take the punt and get the Pro version of CD Collectorz Music and see how it goes.

A quick look at the forums + website shows it has much of what I want from a CD Database including: Release Date and Original Release Date, linking albums to files, multi disc albums. I just need to see how it handles Various Artist CDs...

Meanwhile, I'll still probably use SharpDevelop to build a basic app to edit the bits of my old database that aren't in Collectoz' software. It's already 1000 times more pleasant than coding ASP.