I just installed SQLTunes on my Mac, which creates a MySQL table from exported tracks from iTunes, and allows me to run reports or even create web pages with interactive options via PHP, should I so choose. I set it up on my local host (if I had access to a remote MySQL db, I’m sure transferring the data would be an easy task), and it felt a lot easier than when I installed SimpleMachines Forum or Moveable Type to see how they worked. Both those apps took a couple of hours of Unix related experimentation on the Mac, but SQLTunes only ran me 15-30 minutes. My first report showed 5715 tracks from 588 artists, although iTunes often incorrectly interprets tracks on classical music CDs – probably more related to the database that iTunes checks, than iTunes itself. For example, there is no artist called “Act I Connais-tu le pays…” but that’s how the db assigned a track when ripping the CD. I haven’t ripped all my CDs, but this is a great tool for all sorts of reports (count number of songs with same title, for one), and a different perspective on my music library. No idea if the same thing exists in the Windows/Linux world. One strange quirk is that the track_id field, which stamps all the records with a unique ID, started at 39, not one. Another is that the import from the XML file sorted in no logical fashion, except for maybe the “persistent_id” field, which I don’t know how populates.
Science Fiction
Archives
- December 2024
- November 2024
- October 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- October 2023
- September 2023
- July 2023
- May 2023
- March 2023
- February 2023
- January 2023
- December 2022
- November 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- August 2021
- July 2021
- June 2021
- May 2021
- March 2021
- November 2020
- February 2020
- January 2020
- December 2019
- November 2018
- April 2018
- March 2018
- February 2018
- September 2017
- May 2017
- October 2016
- October 2014
- June 2014
- November 2013
- October 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- March 2012
- May 2011
- April 2011
- March 2011
- February 2011
- December 2010
- October 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- January 2010
- November 2009
- September 2009
- August 2009
- May 2009
- March 2009
- January 2009
- December 2008
- November 2008
- September 2008
- August 2008
- July 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
- November 2004
- October 2004
- September 2004