Python Forum

Hi,

I’m looking to make a small IoT project / test automation with my Raspberry Pi. I have a light and temperature sensor. I want to make an air monitoring system.

I want to take readings every minute, and store them in a postGreSQL database.

I’d like to write a script to then have a script access the database after 24 hours, and plot them over each hour. I assume I’ll use matplotlib.

What I want to use, and I don’t know how, is Docker. I’m not even sure what it is used for in its fullest, but I’d like to try it for a container software / test automation.


Separately, I’d like to like to write a script which would access the database after a week, and do data sorting on the week’s worth of data, and send me a “narrative” report of findings, which I can customize.

Here’s what I can do so far:

I can read sensor data from my RPi to my computer monitor.
I can use PyCharm to interact with postgreSQL and make a table

I’d like to be able to store the RPi data, every minute (or datadump it after 1 hour) into the database as a first step, but unsure how Docker would work with this.

I know it’s a bit vague, but I was hoping to get some help in starting my project.

Thanks!