I like the ideas so far... my concern is that there is quite a bit of code that needs to run to generate things like TV's...
* Okay, do we have a TV?
* Yes we do, which PVR are we using, MythTV, or VDR?
* Okay, create the commands to start.
Moving this to a database will require significant development, and a lot of experimentation..not so much talk..but we need to do some research to see how far we can actually take it. The big mistake of any system (and yes, Pluto makes this mistake constantly), is it tries to be everything to everyone. We need to concentrate on the 80% cases.
But we also need to spend some time building out truth tables for things like building automatic events for lighting, climate, etc., finding out if these devices exist, and creating scenarios to use them efficiently, taking into account house modes.
For example, if house mode is sleeping, and you have motion sensors, you may want events to trigger when you walk to the bathroom, to light a path
you may want to be conservative on lighting the fireplace....
we need to sit down, and seriously map these things out, and give this system the reputation it is grasping for, that of a smart home.
Because, in my opinion, if you're adding all these buttons, that you have to click to do the different things, and castrating events wholesale, you're missing half the point of using this system!