How to gather information into a central 'database'?
Posted: Sun Oct 14, 2012 1:12 pm
Hi Folks,
Currently my domotica environment is evolving in such a way that it get's comfortable.
I use Homeseer
I use Z-wave (DUWI) for light's and sensors
I use 2 Z-wave (Greenwave) powerbars to measure power and turning off standby devices
I use plugwise to measure used electricity for individual devices
In a few weeks i'll get a Smartmeter which probably will be connected with the Plugwise Smile.
Currently i'm trying to build some HStouch screens to get things even easier and more acceptable.
What i'm missing at the moment is one central place/spot where i have some kind of dashboard with the current status of the house.
For my understanding i need some kind of database solution in which:
Plugwise data is injected
Greenwave data is injected
Sensor data is injected
The biggest question is, how do i get the data in the right format into the central database.
I allready tried to do some logging / scripting from from homeseer to get data into mysql.
My biggest problem, i have no clue where to start.
Any idea's? I'm open for everything, even moving away from Homeseer if needed.
Currently my domotica environment is evolving in such a way that it get's comfortable.
I use Homeseer
I use Z-wave (DUWI) for light's and sensors
I use 2 Z-wave (Greenwave) powerbars to measure power and turning off standby devices
I use plugwise to measure used electricity for individual devices
In a few weeks i'll get a Smartmeter which probably will be connected with the Plugwise Smile.
Currently i'm trying to build some HStouch screens to get things even easier and more acceptable.
What i'm missing at the moment is one central place/spot where i have some kind of dashboard with the current status of the house.
For my understanding i need some kind of database solution in which:
Plugwise data is injected
Greenwave data is injected
Sensor data is injected
The biggest question is, how do i get the data in the right format into the central database.
I allready tried to do some logging / scripting from from homeseer to get data into mysql.
My biggest problem, i have no clue where to start.
Any idea's? I'm open for everything, even moving away from Homeseer if needed.