Rockbox General > Rockbox General Discussion
Tracknum sort order in Database
adam917:
Even though this may be a bit off-topic, is it possible for an application to scan all track number tags in someone's music collection and prefix the tags with the desired number of digits as needed by each album (like prefix three zeroes on tracks 1 to 9, two zeroes on tracks 10 to 99, and one zero on tracks 100 to 999, for instance)?
Besides something like that, are there any true benefits with the DB scanning the track number tags (but still outputing them in WPS & tag info screens as strings) as textual strings as opposed to (cardinal) numeric values? If so, can anyone who knows indicate? Would it have to do with track 'numbers' like 1a, 1b, etc?
bascule:
MP3Tag is your friend (link)
And, of course, the database formatting described above does exactly that, but only within the database itself.
roolku:
--- Quote from: adam917 on March 22, 2007, 03:48:54 PM ---Besides something like that, are there any true benefits with the DB scanning the track number tags (but still outputing them in WPS & tag info screens as strings) as textual strings as opposed to (cardinal) numeric values? If so, can anyone who knows indicate? Would it have to do with track 'numbers' like 1a, 1b, etc?
--- End quote ---
Personally I would like to treat track numbers (and year) consistently in database and WPS/info screen and cardinal numbers would be fine with me (that's what my tags are). But some people like the flexibility of having free text to store things like 1/10 or even more obscure things with classical music (there is even a comment in id3.c to that effect).
Now one could make the database use the string representation as well, but numbers are a lot more efficient to deal with and using strings would cause even more sorting problems (i.e. is 02 < 1 ?).
So I think the current compromise is as good as it gets.
adam917:
Exact what is the current compromise? String in WPS & integer in DB?
Posted by: roolku -
--- Quote ---So I think the current compromise is as good as it gets.
--- End quote ---
roolku:
--- Quote from: adam917 on March 22, 2007, 06:13:54 PM ---Exact what is the current compromise? String in WPS & integer in DB?
--- End quote ---
Nearly. WPS uses whatever the Tag (depending on filetype) holds (number or string) and database uses numbers.
Navigation
[0] Message Index
[*] Previous page
Go to full version