probably simple but as always there are many ways to solve simple questions.
So here is my idea:
I have cameras set up arround my house. I tried motion detection but that uses so much cpu and is not really reliable. So I got myself some motion detectors to solve that problem. In my case I have also a alarm system that I arm when I am not at home. First of all I get notificated and sent a picture of all cameras if motion is detected. So good so far. But now I would like to store exactly when motion is detected. So I don’t need to view all the stored videos. Then I can jump exactly to that timestamp and see what caused that motion detection.
For now I use persistance and set up a mysql database. What it does is to store all item changes. But I don’t really know how to view that data other than with simple sql statements from the command line (that’s how I found out that it is actually working).
Any oder ideas or how I could comfortably display the persistance data?
A caution regarding widget; like simple charting widgets, it MAY require some sort of time based persistence strategy, not just changes. I do not know, it would be interesting to find out.