create database then Send data from thingspeak/ esp8266 to the database

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)

Action required:

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

Fähigkeiten: Arduino, Datenbankentwicklung, Microcontroller

Mehr darüber esp8266 receive data from website, connecting arduino to mysql database using esp8266, arduino sql server, esp8266 send data to pc, arduino post data to mysql, send data from arduino to esp8266, nodemcu send data to mysql, esp8266 local database, send data ivr database asterisk, send data blackberry app database, send data html database, send data access database, excel macro send data access database, forms iphone send data database, telerik editor send data database, aspnet greasemonkey send data database, send data database quickbooks web service, create pdf data database, send data iphone database, create api send data mysql database php admin

Über den Arbeitgeber:
( 0 Bewertungen ) Riyadh city, Saudi Arabia

Projekt-ID: #17832342

Vergeben an:


Hello, I Have done such a project with a startup I was working with, they used it for smart metering as well, their idea was to measure water consumption and send it to Sentilo via HTTP requests which then sends the da Mehr

$388 USD in 10 Tagen
(2 Bewertungen)

9 Freelancer bieten im Durchschnitt $447 für diesen Job


Hello. My name is Vusi and I'm an Electronic Engineer, you can learn more about me from my website at [login to view URL] I have a Node MCU dev board and I can develop and test a functional solution for you insid Mehr

$300 USD in 3 Tagen
(11 Bewertungen)

Hi there I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and forme Mehr

$500 USD in 5 Tagen
(1 Bewertung)
$555 USD in 15 Tagen
(6 Bewertungen)

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. i have may experience in Arduino and database development. Timely delivery 24 hours co Mehr

$555 USD in 10 Tagen
(2 Bewertungen)

Hi. I'm an electrical engineer with experience in the programming of ESP8266, designing web server as user interfaces, and connecting with microcontrollers (arduino, pic and raspberry PI) withe the idea to communicate Mehr

$277 USD in 10 Tagen
(2 Bewertungen)

Hi! I have done this kind of work several times so I know how to do this. I have majored in DB especially MySQL for 5 years. I know how to connect the website to the database and make it faster. I have fixed severa Mehr

$333 USD in 3 Tagen
(0 Bewertungen)

Hi, I'm experienced full stack web developer. I also have a good skill in IOT especially in esp8266. I'm really sure I can help you on this as I have almost similar project with this before. Please consider my bid and Mehr

$500 USD in 10 Tagen
(0 Bewertungen)

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

$611 USD in 5 Tagen
(0 Bewertungen)