使用MQTT和SQLite的天气跟踪系统

2017 3rd International Conference on Applied and Theoretical Computing and Communication Technology (iCATccT) Pub Date : 2017-12-01 DOI:10.1109/ICATCCT.2017.8389134

R. Kodali, Venkata Sundeep Kumar Gorantla

{"title":"使用MQTT和SQLite的天气跟踪系统","authors":"R. Kodali, Venkata Sundeep Kumar Gorantla","doi":"10.1109/ICATCCT.2017.8389134","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":123050,"journal":{"name":"2017 3rd International Conference on Applied and Theoretical Computing and Communication Technology (iCATccT)","volume":"85 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2017-12-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"13","resultStr":"{\"title\":\"Weather tracking system using MQTT and SQLite\",\"authors\":\"R. Kodali, Venkata Sundeep Kumar Gorantla\",\"doi\":\"10.1109/ICATCCT.2017.8389134\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":123050,\"journal\":{\"name\":\"2017 3rd International Conference on Applied and Theoretical Computing and Communication Technology (iCATccT)\",\"volume\":\"85 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2017-12-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"13\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2017 3rd International Conference on Applied and Theoretical Computing and Communication Technology (iCATccT)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICATCCT.2017.8389134\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2017 3rd International Conference on Applied and Theoretical Computing and Communication Technology (iCATccT)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICATCCT.2017.8389134","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 13

摘要

每个人都热衷于远程访问某个地方或物体的信息，并使用新兴技术使周围的事物智能化。本文主要研究了利用MQTT协议实现一个从ESP8266发布数据到驻留在树莓派模块上的SQLite数据服务器的框架。这里的传感器被组装到ESP8266微控制器读取值。开发了一个python应用程序来感知来自传感器的值并将数据发布到树莓派。现在，ESP8266充当MQTT客户机，传感器数据被发送到运行在Raspberry pi模块上的MQTT代理。此外，SQLite数据服务器也托管在树莓派模块上，来自ESP8266的数据以JSON格式存储。来自服务器的数据使用HTML文件格式化，格式化后的数据可以远程访问。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

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.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

2017 3rd International Conference on Applied and Theoretical Computing and Communication Technology (iCATccT)

自引率

0.00%

发文量