02-11-2006, 08:12 PM | #1 (permalink) |
Location: Waterloo, Ontario
|
iTunes database specification...
Okay, does anyone know where iTunes stores its database and how the database file is organized? There are many things I would like to do with that data that iTunes simply doesn't do. I can easily write my own software and will be happy to share it with anybody if only I had this information...
If anybody can help, I'd greatly appreciate it! Thank you... |
02-12-2006, 04:29 AM | #3 (permalink) |
spudly
Location: Ellay
|
I think this may be one case where there is a difference between mac and pc users. I'm pretty sure that iTunes stores song data in a xml database in (or adjacent to) your your iTunes music folder. Honestly, I'm not that great yet - my understanding is limited to using the tools that others create. I'm learning slowly though. If you figure out what the deal is with the apple lossless codec''s support for tags, let me know - I've been puzzling on that for almost a week now.
Here are a couple of links that will give you access to people with lots of knowledge: Apple Support Forums has some really advanced cats. There are likely people there who can help, even if you are willing to dig into programming. If you're using a mac, check out Doug's AppleScripts for iTunes. With 386 scripts already written, you can probably find something that will help you. Also for mac users - it has recently become clear that iTunes uses "hidden" tags to manipulate the behavior of some tracks, while not yet providing access to the user. These include episode and season information for TV shows. Lostify will give you access to these hidden tags (at least the TV show ones). Even if you aren't a mac user, some of the info on that site might start you out towards programming your own data manipulation tools.
__________________
Cogito ergo spud -- I think, therefore I yam |
02-17-2006, 03:29 AM | #4 (permalink) |
Upright
|
The iTunes XML file is a mirror of what is stored in the binary database file, but it's not "The" database. If you change the XML, it won't change the real database, and your changes will be overwritten by iTunes. As far as I know, nobody has reverse engineered the DB file format, but you may not need to depending on what you're wanting to do.
(There's more info about this here:- http://www.marteydodoo.com/2005/06/2...-open-formats/) If you're on a mac, you can interface programatically with iTunes using AppleScript, but I'm guessing you're probably not. What is it you're actually wanting to do? Last edited by graf; 02-17-2006 at 03:46 AM.. |
02-18-2006, 12:07 AM | #5 (permalink) | |
Location: Waterloo, Ontario
|
Quote:
For instance, suppose I want to remove all the songs from a playlist from my iPod. You can't actually do that. How weird is this? |
|
Tags |
database, itunes, specification |
|
|