Forgot to add - Got several different buildings in different cities that would have sensor data and I would not like to have more then the sensors + gateways in each house/estate,
Posts made by ltz
RE: Simplest DB storing controller
OK well I guess my need really is an IOT storing solution where the server polling functionality would be running on an external web hotel where I can purchase the uptime needed for the server/storage.
Most of the controllers seems to have third party software needed in order to work. It feels like in the long run - this solution would be an ongoing development/configuration project for both sensors and the server bits. It would be nice not to have 10 different softwares + a dedicated "closet server" just to fill a simple database with 10 sensors data.
Haven't seen any controller that would work to host on for instance a servage web hotel. Got any tips for which solution that might fit me there?
Simplest DB storing controller
Got a need of 1-15 sensors transmitting in to a ethernet connected gateway - then storing these in a database for nice reporting via other tools.. As I look around I can see quite complex controllers which are suitable for controlling home automation. How about the pure simple sensor reading controllers? If I would want a "controller " that would connect to a ethernet gateway via my site router/firewall - picking up data and storing in a database. It would be neat to have something like a php / mysql solution running on an internet based webhotel. Are there any solutions already that would enable this? Primarely I would be using a series of temperature / humidity sensors and electrical power meter Any sensors..
A first idea from my side would be to setup a php MGTT client that would pull the data and store it. But it feels like I would be inventing the wheel again here