I'm building a software, which stores it's data into a mysql database on the pi. The database is also connected to a web interface where I can manage some settings or switch some devices on and off. Now, I noticed, that when I run the python program and change some values in the database, the python script does never notice that.
The python program runs new "SELECT...." statements every couple of minutes, but the results from these selects stay the same. It is working in the very first iteration of the loop, but after that, the values just stay the same. Is this normal behaviour with python or is this just related to errors in my code?