Online thermometer with local backup

Introduction

We use AM2302 (wired DHT22) temperature-humidity sensor with Raspberry Pi. Pi is set up to measure temperature and humidity every $N$ minutes (perhaps 5min), and the is securely sent to online web server if possible. If not, the will be saved to local database and transferred when RPi is online.

The data is visualized using D3.js library with zoom and pan. The current location of RPi can be changed online, and the location is shown on the visualization page.

AM2302 Sensor

https://learn.adafruit.com/dht/connecting-to-a-dhtxx-sensor

Wires:

• VCC - red wire Connect to 3.3 - 5V power. 1st on left. [Brown -> yellow]
• Data out - white or yellow wire. 2nd on left. [Blue -> black]
• Not connected
• Ground - black wire. 4rd on left or first on right. [Green-yellow -> black]

Raspi 1b

I have an old Raspi (not the plus version). The pins are shown here: https://www.megaleecher.net/raspberry_pi_gpio_pinout_helper

Theory

Save the data to local or online database securely

Need to install MariaDB or MySQL server on Raspi. It is straightforward.

To check if internet connection is established, use

iwgetid

command.

Use mysqldump to transfer data from local server to online.