Accessing iTunes Music Library database
I'd like to find some way -- perhaps through third-party applications, add-ons, or just simple programming languages -- that I can query the iTunes Music Library, and do things beyond what are possible within iTunes itself.
For example, I'd like to perform queries such as:
Find all records from PlaylistA that are also in PlaylistB.
Find all records in the entire database that are NOT IN Playlist C.
Find all records in the database with {qualifer 1} and {qualfier 1} and not ({qualifier 3} or {qualifier 4}).
These are all simple queries in something like SQL, but not from within iTunes. What other applications are there that can access the iTunes database in this manner (and, hopefull, with a decent GUI interface)???
For example, I'd like to perform queries such as:
Find all records from PlaylistA that are also in PlaylistB.
Find all records in the entire database that are NOT IN Playlist C.
Find all records in the database with {qualifer 1} and {qualfier 1} and not ({qualifier 3} or {qualifier 4}).
These are all simple queries in something like SQL, but not from within iTunes. What other applications are there that can access the iTunes database in this manner (and, hopefull, with a decent GUI interface)???
Dell Inspiron 9200, Windows XP
