Old database schema

[Auchtermuchty Weather]

My database goes back to October 2012, and the schema is from then.

I notice there are a lot more columns in it now, do I need to concern myself with updating it?

Not having - as far as I know - any schema-related problems with any of the Seasons, Belchertown or Bootstrap skins, nor with the one I made for the Gliding Club.

[p q]

I know of no benefit to removing those columns. My db is from 2016 and also has a bunch of empty columns.

--
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+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/weewx-user/ccf25612-58a9-451f-8515-d90bfd5af57an%40googlegroups.com.

--

Peter Quinn
(415)794-2264

[vince]

There were a number of discussions over the years that said that there is no benefit in removing unused columns.  Re: the bigger wview-extended schema, there is no risk in staying with your old smaller wview-compatible schema if nothing is breaking.  If you later start using a skin or extension and things get dramatically slower, that's a good indication you might need to either add a column or update to the new wview-extended schema.

[Auchtermuchty Weather]

I did mean updating my schema to the up to date one, not removing columns. But since nothing is breaking I'll leave it alone.

[Tom Keffer]

From the wiki article, Switching to the new wview_extended schema:

WeeWX V4.x offers a new schema wview_extended, with many new types. You may find many of these types useful and want to switch to it. Before explaining how to do this, it's worth noting:

1. In WeeWX, the schemas found in schemas/wview.py and schemas/wview_extended.py are used only when the database is created. Thereafter, the schema is read from the database itself, and the Python versions are not used again.

2. While wview_extended is the new, default, schema for V4.x, it is not necessary to "upgrade" to it. Your old wview schema will continue to work just fine. Switch to the new schema only if you find the new types useful.

3. If you just need to add one or two new types, you may find it easier to use the tool weectl database add-column.

To view this discussion visit https://groups.google.com/d/msgid/weewx-user/df8443f9-6afb-4485-ac5d-cbb50cd6cbf6n%40googlegroups.com.

[Auchtermuchty Weather]

Thanks, I think the answer is carry on as at present.

[Auchtermuchty Weather]

I hit other problems so I'm reconfiguring the database to the extended schema.