[in no particular order:]
** Ragnar Kjørstad sugested that the DB resolve down to song titles, for
same-song on diff-cd support. Martin Nilsson suggests something similar,
even suggesting we use the ISRC encoded on some CDs for song identification.
I'm afraid that some/many/most CDs won't have reliable ISRC information, or
that not all players could get to it, so that'd be out. I'm really afraid
that this kind of relational approach, while really cool and great if you're
doing an "Internet Movie Database" approach to CDs, wouldn't be practical
when you've got fairly dumb, non-interactive clients shoving new data at a
server.
** don't store hashed IDs -- just store raw ToC data, let internal DB
implementations decide on a hash for internal speed, and store those in a
separate table. If necessary. This frees clients from any one hashing
algorithm.
** Eddy Gurney points out that ome kind of support to consumer jukeboxes,
that may only return MM:SS info (w/out frame info) for ToC data, would be
good. (Maybe the server can do fuzzy matches for them, but use frame and/or
leadout for systems that can to reduce collisions.)
** Seems to me that we might also have user-defined abbrevs for songs,
artists to better support devices with limited display capabilities (ABITW2,
etc.)
** XML stuff might help us with sending specific datums back to the client
that might not be used everywhere. Or a "property,value" ordered pair sort
of delivery and storage might be in order. XML might make a good local
storage format...
** Larry Kain proposed a cool-named abstraction called "MuRuPu." Should we
dig into something really abstract, or stick closer to a representation of
physical media? Could have good uses when trying to do things like
classical music CDs, with multiple performances of basically the same
material.
** Extended character sets? Should at least leave that open. Seems that
UTF-8 has been suggested as a standard (I don't know enough about this to
comment).
** Multiple languages? Definitely, at least to support multiple title names
(some classical CDs have track titles in English and, say, French and
German)
** Genres -- Mike Bremford suggested three alternatives: CDDB's current
list, MP3 ID3 list, and "main entry with user entered keywords." I think we
could start with the main CDDB categories, then create subs, perhaps.
** Conflict resolution -- I'm inclined to stay with "Latest Entry Wins,"
simply for simplicity. Could we maybe have a "confidence" measure that
could be clicked, and when enough people say "yeah, that looks right," the
record is frozen, and re-submissions get bounced to some "authority" for
resolution? Like I said, "last entry wins" is a lot easier. At any rate,
this isn't a DB issue.
** Robin O'Leary would really like to see some sort of "supertrack" that
encompasses multiple tracks (for ease of proper shuffling choices, among
other reasons). This also allows for entering the "piece" title once (not
having to repeat it on each constituent track). I suggest that a time-based
approach would be better, simply because it offers more flexibility, though
some sort of direct indication of hierarchical location should be retained.
Doing it in a time-based manner also allows for "super tracking" pieces that
split in the middle of a track (not that I can think of any examples, but
hey...)
** I would like to see sub-tracks defined, for splitting out long pieces
(classical, pink floyd, etc.). Some CDs support built-in Index marks, but
most players don't support that, and certainly those aren't included in
CDDB. By taking the same approach as suggested for supertracks, we can skin
both cats at once.
** Last name? First name? Does it matter? Only really important when
trying to do a sort order. Maybe an "artist" field, and a "sort as" or
"file as" field. Enter "Peter Gabriel" in the first, and "Gabriel, Peter"
in the second. Maybe.
** Titles, sub-titles, collection titles--suggest "standard" use for
collection titles as subs ("Billboard Best Music Vol 6 -- The Yoedelers"
becomes "The Yoedelers" as primary title, "Billboard Best Music Vol. 6" as
subtitle.
** many people have requested artist-per-track information, for various
artist CDs. Might even want to add per-track album info, for those
compilations that list original artist and original album
###