Much of what has been requested in this thread and elsewhere on the LAB has been planned and/or implemented already in MacFOH... Sebastiaan Meijer is another developer in the project who has been working on the database schema with me, along with a few others. I'm working with the developers of the Valentina database, and have full access to their source code, and have written a version of it for MacFOH, called "VX", so I can implement all of my custom tuning techniques, essentially rewriting their kernel by the time I'm done, but in essence it has allowed me to develop my own database layer and engine which functions with the existing networked client/server system in MacFOH and MacFOH Remote.
Without going into endless detail (and yes, I could easily geek out about it), I recommend that those interested compile their wish-list of realizable database features and email them to me
. Essentially, MacFOH connects to a shared touring database [online] which stores all kinds of info for venues, gear, etc, and it gets synced to users computers so they have a copy of it locally for offline access, and any updates and changes are made when they have a net connection. A secure user data backup service will be offered in the future, which will operate transparently via the same mechanism, and there is also a standalone MacFOH Server app which companies can operate to host their own private data, in-house and/or online, make hard-copy backups, etc.
FWIW, in a former life, I designed and implemented the business management systems for two heavy-highway construction companies, and was also the Controller and VP of both corporations. I wrote a double-entry accounting system in FileMaker Pro, and programmed all the other systems in Excel, scripts, tools, etc. The accounting system managed all of our heavy equipment, trucks, scheduling, jobs, employees, union wage matrices, contracts, bidding, nearly everything. I also designed and built an asphalt batch plant process control system on Mac, with NiDAQ SCXI interfaces to the HV controls, real heavy-duty "show-control"... mission-critical interlocking, controlling 120 million BTU burners, flame eyes, pneumatics, motors, VFD's, load cells, thermocouples, etc. So as far as experience, I do have some, but suggestions and help are more than welcome.