Rockbox mail archiveSubject: Re: ID3 Database file format
From: Björn Stenberg (bjorn_at_haxx.se)
Peter van Hardenberg wrote:
This is nice, but it only solves the searching part. We also want to be able to _browse_ equally complex queries. This means we not only want to find the relevant files, we want lists of matching artists and albums too:
This could be solved using a few more cross-reference tables:
And cross-match them as you describe to find for example "all artists with albums with Pop songs released in 1981".
Adding another level of complexity, you hint at the desire to match against *ranges* of values ("the 1980s"), which would mean we cannot even limit ourselves to comparing against a single entry in the tables. Code complexity is increasing rapidly! :-)
This brings back my old thinking that Artist, Album and Song are "main" attributes for which browsing is solved in the database without searching. Year and Genre are "filtering" attributes which can be combined with the main attributes, but this will require a bit more cpu work and disk access.
-- Björn _______________________________________________ http://cool.haxx.se/mailman/listinfo/rockbox
Page was last modified "Jan 10 2012" The Rockbox Crew