artsyhonker: a girl with glasses and purple shoulder-length hair (Default)
Things I want to track about music:

Title/First line of text
Composer: Last name, first name, initials, birth year, death year, nationality, website, e-mail, role, link to contact composer, link to composer's website, notes
Arranger: all the info from Composer.
Language
Lyricist
Translator
Date of composition/publication
Publisher (if applicable)
Voicing
Instrumentation
Genre (e.g. hymn, chant, anthem, canticle, responses, voluntary...)
Metre (for hymns)
Tune name (for hymns)
Duration (in time)
Duration (in verses, for hymns)
Difficulty
Hymnals the work is published in
Anthologies the work is published in
Url to order a deadtree copy
url to buy a download
url to a free download, if any legal
url to contact composer
Liturgical context: seasons, saints, services, themes, where in the service it might fit,
Scriptural references (this is fairly complicated because a piece might be relevant to one verse or to a range of them and it might skip some within that range, but at least someone has numbered the chapters and verses already, thank you Dominicans; I almost want to do this with a link to bible.oremus.org because that is a sensible site)
Lectionary Date (there are three years worth of these)
Related works (e.g. a Magnificat may be linked to a Nunc Dimittis)

Some of these are one-to-one relationships, some of them are one-to-many. I don't really get how to do the one-to-many thing, yet.

I think I need the following tables:
Works
People
Hymnals
Urls
Liturgical context
Scriptural context
Lectionary Date
Relationships between works

But, I am not quite sure what I am doing...
artsyhonker: a girl with glasses and purple shoulder-length hair (Default)
OK, for Cecilia's List I will need a database.

That is: the volume of information will get really stupid realyl fast if I try to do it without a database of some sort.

For now, I am happy enough with a database where I ask it for a report (which will include some html formatting) and then copy and paste that into a Wordpress page or blog post. Really! This is because this introduces a layer of human proofreading, and I like human proofreading.

It is over a decade since I did any kind of work with databases at all, and that was... rudimentary, to say the least. So I don't really know what I'm doing.
more on what I need/want, and not knowing how to get it )

Er, are any of you good at databases? I think Zair may be able to help me, but I'd like to get a better understanding of what I actually want before I throw myself at another helpful friend.

Profile

artsyhonker: a girl with glasses and purple shoulder-length hair (Default)
artsyhonker

October 2017

S M T W T F S
1 2 3 45 67
8 910 11121314
151617 18192021
22232425262728
293031    

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Oct. 21st, 2017 10:36 am
Powered by Dreamwidth Studios