Programming is hard

Let's go shopping!

:-/

I got about half of the schema reorg described above done. Some of the "has"es identified above probably should be "belongs_to" (does a production have a theater, a play, a director, or does a theater have a production and a play has the same production and ...? Given that the production is kind of the nexus of the whole thing, maybe it *does* have everything and belong to nothing....Oh heck, I don't know). My brain is kind of fried. Doing this one-handed on six hours of interrupted sleep probably isn't helping.

I'm going to take a break and do something I'm good at: Theater History! Yay!

Why am I calling this project "Henslowe's Cloud"?
The "cloud" part is for cloud computing. Part of the idea here is to put most of a theater's necessary information in the cloud so that if your theater burns down (hey, it happens, just ask Shakespeare...but only if you're performing Henry VIII), you don't lose all your info. Also, having it in the cloud makes it so some technically savvy person (like me woot) can administer it for you remotely. You don't have to worry about anything but scraping up the money to pay her. :)

The Henslowe part is cool.

 Henslowe as played by Geoffrey Rush in Shakespeare in Love.

Philip Henslowe was a theater manager . He wasn't an actor. He bought plays, hired actors, and ensured the whole enterprise made money. He managed the Admiral's Men, which competed with Shakespeare's company.

Yes, this is actually Henslowe's Diary.

The only reason anyone knows or cares about Henslowe is his "diary," a ledger of records for his theaters. It contains entries like this: "pd vnto the tyre man for mackynge of the devells sute & sperethes & for the witche for the playe of the iij brothers the 23rd of october 1602 some of xs ixd" ("paid unto the tireman for making of the devil's suit and ??? and for the witch for the play of the three brothers, sum of 10 shillings, 9 pence"). Thanks to Henslowe, we have some good idea of how much actors were paid, which plays were popular in the time, what kind of inventory the theaters had, in terms of props and costumes, etc. Henslowe's Diary is an incredibly valuable document for theater historians, but it's madly disorganized. Just imagine what Henslowe could have done if he'd only had a relational database!

...Thus, Henslowe's Cloud. I know it's dumb and obscure and theater history in-jokey. I love it all the same.