"Gerard" <
ghendri-n...@hotmail.com> wrote in message
news:9f98b$507fc030$5356543a$40...@cache100.multikabel.net...
> Dana John Hill <
da...@danajohnhill.com> typed:
>> "jrsnfld" <
jrs...@aol.com> wrote in message
>> news:562149be-8ad4-4992...@o5g2000yqi.googlegroups.com...
>> > Nearly everyone on this newsgroup has at least a few discs they will
>> > never listen to again, because very few people can know for sure
>> > which discs those are. Owning CDs is not about listening but about
>> > ensuring the option to listen when the desire might strike.
>>
>> I think about this a lot. I am presently generating a database of all
>> my recordings. I realized this was necessary after I repeatedly
>> purchased discs I already owned. As I have been typing away (I am
>
> I've started such a database (Oracle) many years ago, but gave up after
> realizing that entering all the *works* by Bach and Mozart only (just the
> titles
> of the works, not the recordings of them) would take me too much time I'ld
> not
> like to spend that way.
>
> How did you set up this database?
>
Strictly speaking, it's more of a spreadsheet than a database. A friend of
mine who actually understands computing explained the difference. I just use
OpenOffice. Each unique performance of a discrete musical work gets a row in
the spreadsheet. There are several columns: Composer, Title of Piece,
Soloist(s), Conductor, Ensemble, Playing Time, Label, Catalog Number, Year
Recorded.
It's as simple as can be, and it does everything I need it to. I have to do
some work, of course. For instance, I must add up the timings of all the
movements that make up a larger work. But I have a time-calculator, and, if
I'm lucky, the recording will actually give me the playing time of the whole
piece, and not just the separate movements. Some people may not worry about
playing time, but ever since I got a job in radio, I find it's something I
need to know.
My goal is to get the whole collection inventoried, then put my catalog up
online so I can access it from anywhere. Like from a used CD store, for
instance. And after that, somewhere in the future, I'd like to have all the
music hosted on a secure server which I can call up from anywhere I happen
to be, and listen to any piece in the collection. But that's not a big deal
right now. Knowing what I have is.
As for it taking a lot of time - really, it's not that bad. This morning,
for example, I entered the data for Barenboim's EMI set of the Mozart piano
concerti. I did have to use the calculator to add up the movement times, but
I'm pretty quick about it. And, of course, I get to listen to the recording
while I do the data entry. By the time one concerto ended, I had already
finished with that box. And it was on to my next set of Mozart piano
concerti. And I could just copy and paste Composer and Title of Piece data.
The only things that take a lot of time are sets with dozens and dozens of
really short discrete pieces with titles that include a lot of special
characters.