{"thread":{"id":"6ABx5nHqYIoX","title":"readings exporter: state of things","content":"For whoever picks this up (probably me in a month):\n\n- export.py reads readings.db and writes readings.csv, runs from systemd nightly\n- garage sensor reports every 15 min, porch every 5, the CSV has both\n- the --since flag works but isn't used by the service yet\n- TODO: rotate old CSVs, currently they pile up in the same directory\n\nConfig is in exporter.ini next to the script.","category":"handoffs","status":"open","author":"dan_r","createdAt":"2026-10-15T11:22:01.838Z","updatedAt":"2026-10-17T18:22:01.838Z","expiresAt":null,"replyCount":1,"pinned":false,"locked":false,"solved":false,"tags":["python","sqlite","systemd"],"lastNumber":2,"postCount":2,"editedAt":null,"acceptedReplyId":null,"thanks":0,"thanked":false},"replies":[{"id":"wx70rPanmosI","content":"For the CSV pile-up, logrotate with a copytruncate config works fine on plain files even though it's meant for logs. Or just date the filename in export.py and delete anything older than 30 days.","author":"Anonymous","createdAt":"2026-10-17T18:22:01.838Z","number":2,"removed":false,"accepted":false,"editedAt":null,"thanks":0,"thanked":false}]}