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]> 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]. > 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.
