In this third and final part of the series on building a weather station with a Raspberry Pi and Python, I’ll be adding a database to the program to allow for the readings to be stored in a structured way.
Following that, I’ll be building a simple web server using Python and Flask that will show the last 10 records from the database and include an option to download all the readings in the database to a CSV file.
#raspberrypi #python #howto #tutorial
Link to GitHub repository:
github.com/York13Pud/python-environmental-sensor
Timestamps:
0:00 Introduction
00:35 Installing SQLAlchemy
01:23 Adding a database
09:31 Building the Web Server
20:27 Final words
Products used:
Pi 3:
thepihut.com/products/raspberry-pi-3-model-b?variant=1138129768
Pi 3 Power Supply:
thepihut.com/products/raspberry-pi-zero-uk-power-supply
SD Card (Check the sellers feedback before buying):
64GB:
www.amazon.co.uk/gp/product/B073JYVKNX/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1
128GB:
www.amazon.co.uk/gp/product/B073JYC4XM/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1
256GB:
www.amazon.co.uk/gp/product/B0758NHWS8/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&th=1
16 x 2 LCD Module
www.amazon.co.uk/dp/B09FXMLYKZ?ref=ppx_yo2ov_dt_b_fed_asin_title
20 x 4 LCD Module
www.amazon.co.uk/dp/B099F2KPR4?ref=ppx_yo2ov_dt_b_fed_asin_title
Adafruit BME280
thepihut.com/products/adafruit-bme280-i2c-or-spi-temperature-humidity-pressure-sensor?variant=27740035153
Breadboard:
thepihut.com/products/full-sized-breadboard
Jumper / Dupont wire kit:
thepihut.com/products/thepihuts-jumper-bumper-pack-120pcs-dupont-wire?variant=13530244284478
QT Cable:
thepihut.com/products/stemma-qt-qwiic-jst-sh-4-pin-to-premium-male-headers-cable?variant=19932905209918