search

solmoller / eversolar-monitor

Script to capture data and create statistics from Eversolar/zeversolar Solar Inverters. Includes easy install image files for Raspberry Pi. Working edition since 2012 :-)
https://github.com/solmoller/eversolar-monitor/blob/wiki/Introduction.md
MIT License
30 stars 20 forks source link

db.sqlite size discussion #29

Closed Steve9R closed 6 years ago

Steve9R commented 6 years ago

Discussion / Suggestion

my sqlite db is currently

-rw-r--r-- 1 root root 124765184 Jan 21 09:08 db.sqlite

124mb.. should there be a process for trimming it over time to keep it manageable.. as i can see it just growing and growing and eventually filling my pi storage..I know i can replace it with the blank one but perhaps even gzipping off to archive say every 12months and starting clean every year to avoid corruptions? and huge sizes ?

Steve

solmoller commented 6 years ago

Hi Steve,

I believe there's room for more than 20 years on yesteryears SD card sizes. Given the technological development rate, I see no reason to throw out data that may be interesting for analysis. In the latter versions of the code, there is a table with daily productions for quick overviews.

BR

Henrik

solmoller commented 6 years ago

Closing