Bordies,
I made some more progress on the library. Check out
https://acwe.org/library/index.php
Now you can see what parts are in each piece (instrumentation). Except
that there are none yet, because you have to take inventory and enter them
first!
If you know the instrumentation (for example, you have the cover page or
the score, or a known resource like windrep.org or jwpepper.com) you can
enter it all at once, even though each part is individually saved in the
database.
Most things are linked together. That way you can't accidentally delete a
composition piece that has parts in it (until you first remove the parts),
or you get an error like: Delete failed. Error: Cannot delete or update a
parent row: a foreign key constraint fails (`library`.`parts`, CONSTRAINT
`parts_ibfk_3` FOREIGN KEY (`catalog_number`) REFERENCES `compositions`
(`catalog_number`)).
What remains:
- Parts now include things like "Percussion 1," "Percussion 2," or
"Mallet Percussion" - What it doesn't tell us, is what parts are in
Percussion 1 (snare drum, bass drum, triangle, etc.). That is different for
every piece, so for now you have to write it in the descriptions. This is
the purpose of "part collections", which I will work on soon.
- Add some reports. What do you want to see?
- Clean up. Some spots are a little messy
- Improve performance. It's a tiny bit sluggish (IMO), but it can be
improved.
Have a look, and do let me know your questions and concerns.
PS: come up to Salado today (Saturday) and let me and Bob Russin entertain
you at the local brewery (Barrow Brewing). Starting at 4:30 with the Jolly
Jankin String Band, followed at 7:00 by Bubba Coltrane and the Train Wrecks
benefitting the Salado Volunteer Fire Department