- Posted on
Mon Mar 05, 2018 6:18 am
-
johnpolasek
offline
-
- Posts: 911
- Joined: Aug 05, 2011
- Location: Aggieland, Texas
In addition to allowing us to trim old data from individual variables and devices, it would be useful to have an option to truncate the entire database prior to a specified date; My SQLite database has better than 200 variable and device tables, and until it began behaving badly, I didn't realize that it had grown to over 13 Gig in the past two and a half years. I really don't need anything more than a month or so to drive IndigoPlot, so chopping it off at 6 months back twice a year would be a useful option if I didn't have to do each table individually. And once I saw the size, I was planning on switching to PostgreSQL, except the logger gets a timeout trying to bring up the configuration dialog... got a post in the SQLLogger plugin about that one.