Yes, the other tables are "daily summaries." They are strictly an
optimization. There's nothing in them that cannot be extracted from the
main archive table and, indeed, they can be rebuilt from the latter using
the tool wee_database.
WeeWX is multi-threaded, but not in the way you describe. Yes,
If you want to talk about reengineering things under the hood, that might
be better discussed in the weewx-development group, and I'm sure Tom and
the usual others will chime in a lot there item-by-item.
But yes, the operative word there is 'summary' in the table names. Weewx
keeps the
Side note:
re-reading Vince's post, i had the process backwards - detailed event
records in Archive table; summary/special info in separate tables...
On Sunday, February 28, 2021 at 2:44:18 PM UTC-8 David Prellwitz wrote:
> Thanks for the quick reply! I apologize for any negative connotations
Thanks for the quick reply! I apologize for any negative connotations (not
intended), i guess my perceptions and assumptions are off-base! it's just
in all my professional DB roles (25yrs +) i've had to use visual layout
tools to understand existing data creation, utilization, ranges,
I'd suggest your commentary is more than a little bit unfair and
inaccurate, and I'll leave it at that.
Weewx by default uses an underlying sqlite3 database and puts its readings
into an 'archive' table that has a large number of fields for the actual
weather measurements.
CREATE TABLE
Also, i'll try to just document the base and extended schema's to give a
good base model.
p.s., I'm using Visio as it's the tools i've used for years. If you have a
suggestion for another tool, let me know and i'll see if i can
load/install/use that tool.
On Saturday, February 27, 2021 at
Vince - I did all of that and the schema view is bare, i.e., it's still a
whole lot of nothing other than the field names - and it's not complete
(or even close). I've run a Visio Data Model on Weewx.sdb (my running copy)
and found 114 separate tables; many matching field names. All with the
echo ".schema" | sqlite3 mydatabasename.sdb
or look at
https://github.com/weewx/weewx/blob/master/bin/schemas/wview_extended.py
for the default schema for current v4 weewx.
On Thursday, February 25, 2021 at 1:48:45 PM UTC-8 david.a@gmail.com
wrote:
> Looking through both SQLite and Weewx