For how long do you NEED the database to store records every minute?? Most people manage with an archive record every 5 minutes at most (and some only every 30 minutes!)
How often do you look at your 'every minute' data - do you really need it?? The weewx meso extension builds a database table from the LOOP packets which can cyclicly hold data for say a day to a week, in a separate table, which can be used for some reports/graphs covering the previous 7 days whilst maintaining the weewx database at every 5 minutes say. All depends what you're really seeking, and why. On Tuesday, 14 November 2017 14:56:36 UTC+2, Tom Keffer wrote: > It may be getting big quickly, but so what? > > All weewx queries are bounded in time, which is indexed, so search time > for say, "max temperature this week" is constant, no matter how big the > database gets. > > Unless you are in the gigabyte range, sqlite can handle it just fine. Just > be sure to do regular backups. > > -tk > > On Tue, Nov 14, 2017 at 3:58 AM, <[email protected] <javascript:>> > wrote: > >> >> Hi everyone, >> i'm using weewx under Rpi since few weeks and everything is ok. >> However i need to log the data each minute. Therefore the database >> growing quick quick. >> >> I'm wondering a way to backup monthtly or yearly the database in >> dedicated database and purge the old data. >> At the end, i would like several database as >> weewx_2016.sdb >> weewx_2017.sdb >> weewx_2018.sdb >> ... >> >> I search on the official website and in this group without success to >> achieve this aim >> Any idea? >> >> Thank you >> >> -- >> You received this message because you are subscribed to the Google Groups >> "weewx-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
