You can browse without shutting down weewx. Just pass sqlite3 the location of your weewx database (for me, that’s in /home/weewx/archive).
$ sqlite3 /home/weewx/archive/weewx.sdb SQLite version 3.34.1 2021-01-20 14:10:07 Enter ".help" for usage hints. sqlite> select dateTime, outTemp from archive order by dateTime desc limit 1; 1649078100|48.6 > On Apr 4, 2022, at 6:04 AM, DR <daleeaucla...@gmail.com> wrote: > > I have been looking for some way to open a command line or browser driven > version of SQLite to snoop around inside the WeeWx database just to become > more familiar with the layout. I'm not trying to correct any errors (I am > not that worried about the way I use WeeWx mainly to capture the day and > generate graphs which get posted to my web server), but just want to look > around. Using the latest WeeWx install on a Rasp 400 to play and start to > try to customize a bit. > > > I have, obviously SQLite3 on the system, running or I don't think that WeeWx > would function. I have found the directory where the database exists based > on the documentation in the User Guide. I can't find any documentation as to > how to trigger SQLite so I can uses command lines, and while there are a few > things for Linux that say they allow you to open a browser like window to > look at the database, once I download them, I don't find where they are > installed or how to trigger them to open up. I assume from the screen shots > of them that there is a way to change directories until I get to the WeeWx > database, but can't even try doing that. > > > Oh, once I get to be able to do this, do I have to shut down WeeWx while I > look around, or can WeeWx continue to access the SQLite database at the same > time to keep updating it when it needs to? Or is there a collision and it > will require a restart of WeeWx to pickup again once I'm done peeking inside? > > Dale > > > -- > 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 weewx-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/6791f34e-ce65-d411-a7f0-511f58e02c26%40gmail.com. -- 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3FEE78FC-DEFF-429D-A57A-FA71A5B04CB3%40johnkline.com.
