Maybe its better to explain what I want to archief.
I want to make a wireless (esp8266, mysensors or propriety) pulse sender (for messuring gas, water etc) and put the data in a MySQL database. I don’t what use Domotics or something like that…
To make it easy I thought to receive the info with Pimatic (that is easy) where the data will be stored in the pimatic database for a limited period of time.
Then I can query the database, get the agregated info out of the pimatic database (select … group by…) and store this in the mysql database (which is serverd by another raspberry pi).
Then I can play around with the data from there (making all kind of graphs …).
The reason I want to do it this way is because the Pimatic raspberry has wifi, 433Mhz and 868Mhz receivers, the other Pi (with the mysql database) doesn’t.
And I also wouldn’t have any idea how to receive the info with the other Pi (with MySQL on it).
So querying the Pimatic database would solve this for me (I think)…
Any suggestion would be nice…