[rodgersorgan] Re: Music library databases
- From: Doug Brickett <dbrickett@xxxxxxxxxxxx>
- To: rodgersorgan@xxxxxxxxxxxxx
- Date: Fri, 22 Aug 2003 23:10:03 -0600
Arlene-
I've been cataloging my music in my personally-designed database for
the last 20 years or so. When I set it up, I created several
different, related (as in relational database) tables. I keep data in
the following tables with relationships between them:
Hymntunes
Hymn Titles
Composers
Music Pieces (individual pieces of music)
Books
Magazines
Purchase Orders
Scriptures
Instruments
Seasons
Services (based on date)
(and maybe some more that I can't remember off the top of my head)
Since I built them as relational tables, I can, for example, go to a
specific scripture and find out which tunes reference that scripture,
then what pieces of music reference those tunes. I have enjoyed doing
it but it's been a LOT of work setting it up. Maintaining it isn't
bad, though. If you like, I could send you details (once I remember
where I put the database design). I use FileMaker on the Macintosh but
FileMaker is also available for the PC platform and there are many
other database products out there, as well.
I seem to remember, from the AGO convention, that someone has a
commercial product out there to do this but I don't remember the name
or anything about it. It might be worth asking the folks at
www.agohq.org if they remember anthing about it.
Doug Brickett
On Sunday, August 17, 2003, at 05:15 PM, Arlene Jutting wrote:
>
> Hi everyone: Do any of you have any information or use a database to
> catalog your collection of organ music and or other music. I'm looking
> for an existing database of organ music from which I can select and
> move
> the data to my own personal database and be able to sort it by
> Composer,
> Hymn Tune, Scripture Reference, Liturgical Season, etc. Would also
> like
> to keep a record of the date each piece of music was used. It's true,
> I'm lazy as I have a an organ collection of over 50 years as well as an
> even older collection of classical, sacred, and pop piano and vocal (no
> choir music). If you have any suggestions I'd be delighted to hear
> them. And yes, I'm still organist at our church (over 35 years) and
> thoroughly enjoying a Rodgers 957 with PR300. Many thanks, Arlene
>
>
> !
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Find new MIDI music and Guides to Rodgers Organs at www.frogmusic.com
>
> To post send messages to: rodgersorgan@xxxxxxxxxxxxx
>
> To unsubscribe or change mail delivery (digest, vacation)
> go to www.frogmusic.com/rodgersmem.html
>
>
!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Find new MIDI music and Guides to Rodgers Organs at www.frogmusic.com
To post send messages to: rodgersorgan@xxxxxxxxxxxxx
To unsubscribe or change mail delivery (digest, vacation)
go to www.frogmusic.com/rodgersmem.html
Other related posts:
