pfarrell Wrote: > > I didn't catch that you see this as being online. > Accessible with some suitable CGI or WebApp? > > > The least amount of work would be to open up the database for remote > access (using, for example, JDBC or ODBC). CGI or a WebApp would be > more work but would give us more control. > > > pfarrell Wrote: > > > > Ludwig van Beethoven: Symphony No.9, Op.125 "Choral" in d Minor is just > > one of the ways to list it. > > > > > > The format of the title of the composition is not an issue here. The > > data goes into three columns: > > > > Composer: Ludwig van Beethoven > > Composition name: Symphony No.9 "Choral" > > Opus: 125 > > Key: D Minor > > > > The users can all select their own format for the track title. > > For example, > > > > %c(f l): %t, Op.%o in %k > > > > Might then tag the track as per your suggestion. Another user might > > not want the composer's first name or the key signature in the track > > title. That would be no problem - the user simply edits the track > > title format to "%c(l): %t, Op.%o". > > > > I note that you place the opus between the symphony number and the > > symphony name. This suggests we are perhaps going to need more > > columns, and split the composition name into: > > > > form: Symphony > > number: 9 > > name: Choral > > > > I did not do this to keep things simpler, but if we do this, this gives > > us even better searching capabilities (e.g. "find all symphonies in d > > Minor" would be a very simple SQL query). > > > > > > Robin Bowes Wrote: > > > > > > Have you seen http://musicbrainz.org ? > > > > > > > > > I had not. It does seem they are doing a large part of what I would > > > like to have done, so I really appreaciate that you referred me to > > > their site. What they are not doing is separating the database from > > > the tagging. My idea is that the database is far less flat. For > > > example, my idea is that a single record exists for each composition. > > > Any performance of that composite has a foreign key to that record - it > > > does not duplicate the information. For example, any CD that has a > > > performance of Beethoven's ninth would simply say "tracks 2 thru 5 are > > > Beethoven's ninth". If someone changes the data for Beethoven's ninth > > > (say, they add the key "in D minor" which has not been previously > > > entered) then that information would then automatically retroactively > > > appear on all prior CD's that contain a performance of the work. This > > > is very important to get my searches right. If I search for a list of > > > pieces by Beethoven, I would want his ninth to appear just once in the > > > list. Only if I select it and I have more than one performance should > > > I see I list of performances (orchestra/conductor/choir). > > > > > > It may well be that I am better off working on adding this sort of > > > functionality to musicbrainz, rather than duplicating the useful bits > > > that they have done. > > > > > > I will have to look more at musicbrainz. It may be that the program I > > > have to extract the data (composer, movement number, opus, key > > > signature etc. etc.) from the freedb database could be obsolete, or at > > > least a lot easier if we extract from the more consistent musicbrainz > > > database. > > > > > > > > > Browny Wrote: > > > > > > > > Don't know if this would be of interest to you: > > > > > > > > http://forums.slimdevices.com/showthread.php?t=19451 > > > > > > > > > > > > It seems to me that we are trying to do different things. I am > > > > interested in the consistency of the data. The scanning times are not > > > > an issue for me as I don't really care if it takes all night. However, > > > > your work in using the database more rather than the tags may help with > > > > the consistency of the data.
-- nwestbury ------------------------------------------------------------------------ nwestbury's Profile: http://forums.slimdevices.com/member.php?userid=3284 View this thread: http://forums.slimdevices.com/showthread.php?t=19858 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/ripping
