! I have been researching this and found just what you suggest: I need to install sqlite3. Not knowing much I have been concerned that sqlite3 will interfere with the weewx database. From what I see it is a stand alone utility that I can use to access weewx.sdb AND not a database installer. THANKS Vince, a project for tomorrow. Wish me luck.
On Monday, August 4, 2025 at 6:29:05 PM UTC-4 vince wrote: > You likely need to install the sqlite3 utility. > > On Monday, August 4, 2025 at 1:16:39 PM UTC-7 [email protected] wrote: > >> Thank you for the quick reply... I am sure my lack of Pi / SQLite >> knowledge is at issue here. >> I pasted: >> *echo "select >> datetime(dateTime,'unixepoch','localtime'),dateTime,rain,rainRate from >> archive order by rowid desc limit 20;" | sqlite3 weewx.sdb* >> into the terminal as the user Pi (pi@raspberrypi:) and get back: >> *bash: sqlite3: command not found.* >> >> Adding the preface *sudo* did not change the response. >> >> If more explicit instructions would help, please advise. >> Den >> On Monday, August 4, 2025 at 3:43:25 PM UTC-4 vince wrote: >> >>> >>> https://github.com/vinceskahan/weewx-odds-and-ends/blob/master/fix-bad-rain.md >>> >>> is one way to do it >>> >>> On Monday, August 4, 2025 at 10:13:29 AM UTC-7 [email protected] wrote: >>> >>>> Hardware maintenance resulted in 1.63" of daily rain data that is not >>>> real. Is there an easy way to correct this error? >>>> I am running WeeWX 5.0 on a Raspberry Pi. >>>> Thanks, >>>> Den >>>> >>> -- 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 visit https://groups.google.com/d/msgid/weewx-user/e2113a7d-0bae-415d-b38e-af73658aa081n%40googlegroups.com.
