Ok, I'm trying to cleanup the future dates and I'm a little lost... I made a copy of the DB in /var/tmp and ran the following.... root@deadduck:/var/tmp# echo "SELECT * FROM archive WHERE (windSpeed > 80);" | sqlite3 /var/tmp/weewx.sdb 1321130400|1|10|30.083|34.79414|44.235535|73.5|53.200001|17.0|24.0|81.0|225.0|115.0|270.0|72.0|1.1|17.36064|53.200001|53.200001|0.0||||||||||||||||||||100.0|0.0|683.0|||||||||| 1321132200|1|10|30.073|34.784264|44.223541|72.099998|53.0|18.0|26.0|82.0|315.0|118.0|67.5|82.290001|1.25|19.047731|53.0|53.0|0.0||||||||||||||||||||98.0|0.0|684.0||||||||||
How do I identify the dates to delete? I'm assuming there's a date field? What's the format? I need to delete all dates from 8/18/19 to current. Thanks, Troy On Fri, Feb 7, 2020 at 10:03 AM vince <[email protected]> wrote: > On Friday, February 7, 2020 at 7:31:01 AM UTC-8, Troy Lass wrote: >> >> I live in a high wind area and like to watch what's happening when I'm >> not around. It's not unusual for us to get over 100MPH and I like to know >> when it gets up there... >> >> >> > That sure sounds like a reason to want to use the logger and weewx's > capability to gracefully catch up when your location has a power outage..... > > That's a lot of MPH :-) > > -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/ic4IK_-eX4Q/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/e52b4eb7-2f33-40b8-bb92-61066300e849%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/e52b4eb7-2f33-40b8-bb92-61066300e849%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CALBrUnFjVdk3x94Z7T6q3urS1x4cvHumgAreHJmkoAvfF%3Ddyqg%40mail.gmail.com.
