How can I create a searchable web based database of a million mp3 files and import data from iTunes XML files?

Ray Ciccarello May 8, 2011
Pinterest Stumbleupon Whatsapp
Ads by Google

Say you have a million mp3s and you would like to inventory them, kinda like shown in this MakeUseOf article EMDB - Eric's Movie Database for All Your Video Organizing Needs (Windows) EMDB - Eric's Movie Database for All Your Video Organizing Needs (Windows) Read More , perhaps something that takes the iTunes database XML file and makes it into a searchable web based app? Or take the database file and import it into a customizable web app? Ever hear of such a beast?
Thanks,
RC

  1. Ray Ciccarello
    May 22, 2011 at 3:33 pm

    No, I have not tried yet. I did look, but it makes my brain hurt. I'm going to try with my wife's smaller itunes, my xml is 77mb's with 57,000 songs. I know a very little PHP, but that is where I'd like to end up plugging the data base into mySql and having it hosted so anyone can search it.

    I will read on!

    Thanks!

  2. Tina
    May 15, 2011 at 8:01 am

    Ray,

    did you try Mike's suggestion? Did it work out for you?

  3. Mike
    May 8, 2011 at 9:04 pm

    If you actually have all million mp3s in iTunes I suggest to use the database XML and transform it into something visual using XSLT.
    http://www.w3schools.com/xsl/

    If you don't want people to actually see and/or have access to the XML and XSLT you can use server sided transformation via ASP or PHP
    http://www.w3schools.com/xsl/xsl_server.asp
    http://blogs.sitepoint.com/transform-php-xslt/