iTunes Store: Bad Database Design Choices?

Tom Bradford details the problems he’s having with iTMS:

I purchased quite a bit of music in the past using my old email address. As many people do, I recently left the company that I had been working at, and moved over to a new machine and email address.

I moved my iTunes library over to my new computer, and I changed my account’s email address on the Apple web site. When I went to play music that I had purchased, I found that these files had been explicitly linked to my old email address rather than to some sort of primary key that would allow me to authorize no matter what my current email address is. As a result, I can no longer play any of my purchased music.

Having just changed my email address, I might have the same problem. Fortunately, I am still holding onto my old address, at least until someone decides to remove my account. Still, I cannot help agreeing with Tom:

These are things you learn in ‘Databases 101′, and so it’s more than a little bit shocking that developers at big companies make such poor design decisions.

7 Responses to “iTunes Store: Bad Database Design Choices?”


  1. 1 Antonio Gallardo

    and so it’s more than a little bit shocking that developers at big companies make such poor design decisions.

    I think this is more common than you expect. It happens all the time. Thanks to that small companies can live. Long live big corporations!!! ;-)

  2. 2 norman richards

    You can change your apple ID email address easily. The email address is your login, but it isn’t your actual ID. The ISP that had my old email address disappeared without giving me any notice. When I changed my apple ID, all my old songs were associated with my new id. Nothing was lost. I was amazed by how well apple thought out the process and made sure your songs weren’t associated with a dead email address. The only problem I’ve had was with a friend whose email changed and who started using a .mac account. It was trickier to move there. (had to contact apple to “consolidate” the old apple ID with the .mac apple id.

  3. 3 Samual Icky

    hmmm… I’m in the same boat as norman here… Tom Bradford must have something else going on.

    I’ve changed my email address/Apple ID 2-3 times now. First my I had an *.edu address then I went with my tdl address and now I’m using a gmail address. I’ve never had any problems.

  4. 4 ugo

    I’ve just changed my Apple ID to a different email address and even though my purchased music still shows my old Apple ID, I can play it fine.

  5. 5 J. A. Golden

    Also looks like it’ll be a problem if you decide to drop your .mac address: I just tried to change my e-mail address from a .mac account to a gmail address on the Apple website, and got an error message saying I can’t. Bummer, looks like I’ll have to call Apple about it :-/

  6. 6 Alex

    I just changed the email address for my apple id account. the id is still my mac.com address but it is now associated with my yahoo account. I had to change it by going to https://myinfo.apple.com/cgi-bin/WebObjects/MyInfo — I couldn’t change it from within iTunes itself.

  7. 7 Esteban

    I just got my 2000t and all of my songs are skipping in iTunes, and I cant figure out why. If someone could help me out and tell me how to fix this I would really appreciate it because its driving me crazy. Thanks for the replys.

Leave a Reply