I have an IoT project that simulates the smart meter concept :
I have sensors to measure the voltage, current and watts.
The project uses esp8266 to send data to thingspeak and Adafruit.
I use my website to turn on/off the lights and to show the voltage, current and watts by using thingspeak Iframe.
I want to have a database that records the watts in hourly basis to calculate the consumption and to show
some charts to simulate a client and a service provider points of view (watts consumed in specific period of time, cost, peak times ..etc)
1- Create database that records the consumption (watt hours)
2- Create charts that can be controlled with buttons to show (watt consumed/month , comparison with last year, peak times …etc)
I thought there are two options after creating DB:
1- integrates the DB with my thingspeak account to get data required
2- make a command to make esp8266 send data to our new database in the same time its send to thingspeak
9 Freelancer bieten im Durchschnitt $447 für diesen Job
I did similar kind of [login to view URL] poject is based on lighting control and read power consumption values using ACS712 and update to database and show to user in realtime.I can do this project easily