In this third and final part of the project about building a weather station with a Raspberry Pi and Python, I’ll be adding a database using SQLite 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:
https://github.com/York13Pud/python-e...
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:
https://thepihut.com/products/raspber...
Pi 3 Power Supply:
https://thepihut.com/products/raspber...
SD Card (Check the sellers feedback before buying):
64GB:
https://www.amazon.co.uk/gp/product/B...
128GB:
https://www.amazon.co.uk/gp/product/B...
256GB:
https://www.amazon.co.uk/gp/product/B...
16 x 2 LCD Module
https://www.amazon.co.uk/dp/B09FXMLYK...
20 x 4 LCD Module
https://www.amazon.co.uk/dp/B099F2KPR...
Adafruit BME280
https://thepihut.com/products/adafrui...
Breadboard:
https://thepihut.com/products/full-si...
Jumper / Dupont wire kit:
https://thepihut.com/products/thepihu...
QT Cable:
https://thepihut.com/products/stemma-...