After getting the movies section up and running, the next obvious step was getting the music section. Previously it old versions of the websites, a list would show all my music and you can drill down into the album, artist etc. Now that was all find and dandy, but it was time consuming to put it all in the database. When I first created it I didn’t plan ahead as to what it could be used for. In the end, it’s too hard to export it from iTunes and then import it into the database somehow.
So I thought about somehow exporting XML and on the fly parse it on the webpage. That worked OK, but the major problem with it is it took too long. and I mean a LONG time. This technique would work with a small sample set, but I just have too many mp3’s for it too work properly. I also wanted it so you can easily click on an artist and view all the mp3’s I have of that artist as I download full album’s quite often.
So what have I done. Well by using a Wordpress plugin called iTunesBlogger and WPiTunes I can now show you guys what I’m listening too in real time. Granted it doesn’t have my whole mp3 library, it will show you what I’m currently listening to. (95% of my library I don’t listen to anyway). Everything is saved into a database so I can query that later.
What’s the future of it. First thing that pops to mind is using AJAX for realtime updating of the current list. It’s something I want to dive into anyway. Secondly, I can query the database to see what my most popular song is, what is the least, etc. The possibilities are endless!