i think you guys are making this entirely too complicated... this is an album level, not a track level, function. the only comparison i care about is at the album level. i'll take whatever art and individual track versions exist with the album that is selected.
i require retention of browse music folder, yes.. that is how some people get access to the collections that they have put together and understand the structure of. the higher level browses & searches though should only select the more information dense / more complete version of an album. for example, the following query does 95% of what is required: select C2.id, C2.title, C2.contributor, C2.year, SUM(tracks.filesize) FROM albums as C1, albums as C2 JOIN tracks WHERE C1.title = C2.title AND C1.contributor = C2.contributor AND (c1.year = c2.year OR c1.year = 0 OR c2.year = 0) AND C1.id < C2.id AND tracks.album = c2.id group by tracks.album order by title; i'm not talking about eliminating piddly differences in the tags. if someone wants to build independent heuristics for that, it would certainly be cool to allow them to build comparison regexps or something, but thats not the point here. my collections are meticulously organized and the tags normalized. as demonstrated in that query, we're just looking at albums which have the same title, artist, year, and then adding up all of the filesizes within that album, and ultimately (although this step is not in the query above) selecting the largest response per similar album, and perhaps tagging the rest with a new schema boolean "hideThis". i agree that normalization and correction of tags is an external problem. but if they are already corrected, and i have two versions of the same album, i want only the best copy, as defined by a very simple and inexpensive heuristic which can be applied to existing tags, i want only one response to my searches and browses. clear now? -- chroma ------------------------------------------------------------------------ chroma's Profile: http://forums.slimdevices.com/member.php?userid=22010 View this thread: http://forums.slimdevices.com/showthread.php?t=74288 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
