Mar-26-2021, 08:14 PM
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!
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!