Weather tracking system using MQTT and SQLite

Every person is enthusiastic in accessing the information about certain place or object remotely and to make the things around them smart using new emerging technologies. This paper mainly focus an implementation of a framework of publishing data from ESP8266 to SQLite data server hosted on Raspberry pi module using MQTT Protocol. Here the sensor is assembled to ESP8266 microcontroller to read the values. A python application is developed to sense the values from sensor and to publish the data to raspberry pi. Now, ESP8266 acts as MQTT client and sensor data is sent to the MQTT broker running on Raspberry pi module. Additionally SQLite data server is also hosted on the Raspberry pi module and the data from the ESP8266 is stored in JSON format. This data from server is formatted using HTML file and the formatted data can be accessed remotely.