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...

Worklog

Jun. 19th, 2017 02:14 pm
artsyhonker: a girl with glasses and purple shoulder-length hair (Default)
Spent some time this weekend thinking about relational databases; I think I've figured out what structure I need, with some help from that [personal profile] hairyears, but I'm not really much closer to figuring out what software to use to achieve this. More on that in another post.

I'm thinking about whether to have a regular-ish Twitter chat for #CeciliasList, and so far most who have filled out the poll seem to like the idea. Maybe one or two Mondays a month? Not sure about timing, that's probably another poll. I do need to keep this manageable alongside a PhD. Similarly, I'd love to have some kind of launch concert -- on 22nd November, of course -- but I don't really see how I can organise one between now and then, unless I do it as some kind of scratch choir thing (but they work better for well-known works and a lot of these ones won't be).

I put some competition deadlines into my calendar.

I finally have both postcards and scores for sending out this month's Patreon rewards.

I took last week very gently, and this week is looking like very hot weather. The next composing deadline isn't until the end of July (I decided to scrap Leith Hill), so I'm hoping to spend the next couple of weeks basically finishing things off and tying up loose ends, of which I have a few floating about.
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

September 2017

S M T W T F S
      12
3456789
10111213141516
17181920212223
24252627282930

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 23rd, 2017 07:50 pm
Powered by Dreamwidth Studios