Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Keep duplicate songs off of iTunes Smart Playlists' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Keep duplicate songs off of iTunes Smart Playlists
Authored by: nathanw on Nov 22, '06 01:34:37PM

Arguably, the deficiency here is that iTunes isn't actually a relational database. You want to have queries (smart playlists) that do "select from tracks where album=Studio" and "select from tracks where album=Soundtrack" and have this particular track show up in both - you'd have a table of tracks and then a table for the album->track mapping, and then it wouldn't need two copies of the audio file, either.

I sometimes doodle about the right database schema for this application, as I would like to avoid the copies I have due to having albums, CD singles, and compliations with the same tracks.



[ Reply to This | # ]