OSA is an object oriented home automation software. Any property of any object within OSA can be configured to log its value to a MySQL database. Currently all value are logged to a single table with a reference to the object/property associated with each value and a timestamp. OSA does not use "feeds"
I have many logged values in the OSA / MySQL table so I don't want to replicate them into the emoncms database. Instead I'm thinking of creating views with the same names and structures as the emoncms tables. In this way as little as posssible would have to be changed in emoncms. Of course emoncms would not be able to write back to the views like it can to a table. Would this cause a problem? I don't care about user logins/security. Everything can be open to anyone
emoncms with Open Source Automation
Submitted by Automate on Fri, 03/08/2012 - 04:06I'm thinking of using emoncms with Open Source Automation (OSA) www.opensourceautomation.com/index.php
OSA is an object oriented home automation software. Any property of any object within OSA can be configured to log its value to a MySQL database. Currently all value are logged to a single table with a reference to the object/property associated with each value and a timestamp. OSA does not use "feeds"
I have many logged values in the OSA / MySQL table so I don't want to replicate them into the emoncms database. Instead I'm thinking of creating views with the same names and structures as the emoncms tables. In this way as little as posssible would have to be changed in emoncms. Of course emoncms would not be able to write back to the views like it can to a table. Would this cause a problem? I don't care about user logins/security. Everything can be open to anyone
Does this approach sound like it should work?
Thanks,