Clicks and mortar  #
Friday, 01 Apr 2011 04:20PM
One of the things I've been doing instead of blogging (apart from working!) is working on my CD Database.

I've been using the frankly unbeatable collectorz.com Music Collector (and I say that as someone who spent years writing his own CD database).

I intend to start work on Book Collector and Movie Collector once I'm finished with my CDs.

One of the ace things I can do with this database is export to XML, then use my XSLT skills to dump out all sorts of statistics. I hope to update my album statistics series once I'm done.

Meanwhile, here are some interesting stats on where I've been buying my music lately (from about May last year to Mid March). In this table I've ignored gifts and CDs that came on the front of magazines (even if bought them second hand):

Amazon (com + uk)33%
JB HiFi42.5%
At Gig1.5%
Second-hand brick'n'mortar1.5%
Second-hand eBay (US/UK/Aus)10.5%
Second-hand market4%
Record company website3%
Digital iTunes4%

... or ...

New CD online36%
New CD in-person44%
Second-hand online14.5%
Second-hand in-person1.5%
Digital4%