This is a rant rather than a question or anything...
I use Synergy to run an AppleScript every time the track changes in iTunes. The script I run is a heavily customized combination of the scripts from here and here. I wrote an application for my website in PHP + MySQL so I have a database of my music online. While doing this, I was trying to think of something that I could key off of that would never change for a given track, so I could keep track of it even if I change the song name, artist, album, etc. for said track. Well, lookie there, iTunes gives each song a unique database ID. So I keyed off of that. Worked great, still working on the display aspects of the PHP script but everything was humming along fine.
Then I saw news of iTunes 5 being released and after work yesterday I rushed to my Mac to download it. I backed up my library first, just in case, then installed it. I love the new look, especially the fact that more fits on the screen, and other than minor gripes about the way folders were implemented (really, they couldn't come up with anything better than Smart Playlists disguised as folders?) I was happy.
Until today.
Whilst showing off the website portion of my set up to a friend, I uploaded the details of some changed tracks, then viewed one of the albums that I had changed in my online database. A track appeared twice. I went into iTunes and searched, thinking this was one of the duplicate tracks I had missed cleaning out when I had some issues a while ago. Nope, the track is only in iTunes once. I went in phpMyAdmin and searched for the track's name, and it appeared twice, with two different database IDs. I then checked another album that had been modified - same thing, track appears twice.
THEY CHANGED THE $*(%&$(&%&($*&%(&$%&$ DATABASE IDS FOR EVERY SINGLE SONG!
I *never* thought that would happen. The whole point of a unique ID in a database is it never changes. I have pretty much figured out what did happen - the update process done on my library upon launching iTunes 5 for the first time rewrote the database starting with 1, and the numbers changed because tracks have of course been removed since my library was started.
So, while I could simply reupload my library's details again (which would take a bit but not be a huge deal), my playlog, which tracks what I have listened to and when, and does so by database ID, is now useless for everything prior to the upgrade.
WTF!!!!!
What's the point of even redoing this if they are going to mess with the database IDs every time there's an upgrade? This is bull****.
I use Synergy to run an AppleScript every time the track changes in iTunes. The script I run is a heavily customized combination of the scripts from here and here. I wrote an application for my website in PHP + MySQL so I have a database of my music online. While doing this, I was trying to think of something that I could key off of that would never change for a given track, so I could keep track of it even if I change the song name, artist, album, etc. for said track. Well, lookie there, iTunes gives each song a unique database ID. So I keyed off of that. Worked great, still working on the display aspects of the PHP script but everything was humming along fine.
Then I saw news of iTunes 5 being released and after work yesterday I rushed to my Mac to download it. I backed up my library first, just in case, then installed it. I love the new look, especially the fact that more fits on the screen, and other than minor gripes about the way folders were implemented (really, they couldn't come up with anything better than Smart Playlists disguised as folders?) I was happy.
Until today.
Whilst showing off the website portion of my set up to a friend, I uploaded the details of some changed tracks, then viewed one of the albums that I had changed in my online database. A track appeared twice. I went into iTunes and searched, thinking this was one of the duplicate tracks I had missed cleaning out when I had some issues a while ago. Nope, the track is only in iTunes once. I went in phpMyAdmin and searched for the track's name, and it appeared twice, with two different database IDs. I then checked another album that had been modified - same thing, track appears twice.
THEY CHANGED THE $*(%&$(&%&($*&%(&$%&$ DATABASE IDS FOR EVERY SINGLE SONG!
I *never* thought that would happen. The whole point of a unique ID in a database is it never changes. I have pretty much figured out what did happen - the update process done on my library upon launching iTunes 5 for the first time rewrote the database starting with 1, and the numbers changed because tracks have of course been removed since my library was started.
So, while I could simply reupload my library's details again (which would take a bit but not be a huge deal), my playlog, which tracks what I have listened to and when, and does so by database ID, is now useless for everything prior to the upgrade.
WTF!!!!!
What's the point of even redoing this if they are going to mess with the database IDs every time there's an upgrade? This is bull****.