Remove unnecessary`UNIQUE` index on`PRIMARY KEY` columns in SQLite, achieving
size reduction of ~10%. Existing database schemas are not modified. Users
desiring size reduction are advised to consider manually migrating.
FYI: Generally, a SQL optimizer considers in its costs when a column is
unique. I would suggest not removing the attribute.
---
pablo
On 2026-02-23 17:50, Tom Keffer wrote:
A second beta version of 5.3.0 is available.
New changes since beta-1.
Set log-label in sysV init script to 'weewxd-XXX' instead of just 'XXX'
Added rsyslog config example for making logs visible to weewx group without
having to use any privilege escalation.
Allow extra command line options to be passed to extension installer.
Addresses[Issue #1041](https://github.com/weewx/weewx/issues/1041).
Added Astronomical Units as a unit of length. Added`local_djd` as a unit of
_local_ time.[PR #998](https://github.com/weewx/weewx/pull/998). Thanks to
user Karen!
Remove unnecessary`UNIQUE` index on`PRIMARY KEY` columns in SQLite, achieving
size reduction of ~10%. Existing database schemas are not modified. Users
desiring size reduction are advised to consider manually migrating.
Fix problem that prevented`weectl database reconfigure` from working in cases
where a schema was specified.
Fix problem when importing data into a MySQL database. PR
[#1025](https://github.com/weewx/weewx/pull/1025). Thanks to user Robert!
Fix problem that prevented`weewxd` from restarting reliably if a MySQL
connection was lost. Fixes[Issue
#1036](https://github.com/weewx/weewx/pull/1036).
On Sat, Jan 17, 2026 at 3:04 PM Tom Keffer <[email protected]> wrote:
The biggest change is in the database API to allow new databases
to be installed as an extension. An extension for support of
PostgreSQL is available
<https://github.com/tkeffer/weewx-postgresql> as a proof-of-concept.
All changes listed at the bottom.
*pip*
To install the beta version using pip, use the command:
pip install --index-url https://test.pypi.org/simple/
--extra-index-url https://pypi.org/simple/ weewx==5.3.0b1
*Debian*
For Debian, go into /etc/apt/sources.list.d/weewx.list and change
the line
deb [arch=all] https://weewx.com/apt/python3 buster main
to
deb [arch=all] https://weewx.com/apt-test/python3 buster main
then proceed as normal
*Redhat*
Redhat is similar. Edit the file /etc/yum.repos.d/weewx.repo and
change the line that reads
baseurl=http://weewx.com/yum/weewx/el$releasever
to
baseurl=http://weewx.com/yum-test/weewx/el$releasever
then proceed as normal
*Change list*
Moved database-specific code into the `weedb` module. This is in
anticipation
of allowing new databases to be installed as an extension.
Set log-label in sysV init script to 'weewxd-XXX' instead of just 'XXX'
Added rsyslog config example for making logs visible to weewx group without
having to use any privilege escalation.
Allow extra command line options to be passed to extension installer.
Addresses issue #[1041](https://github.com/weewx/weewx/issues/1041).
Added Astronomical Units as a unit of length. Added`local_djd` as a unit of
_local_ time.[PR #998](https://github.com/weewx/weewx/pull/998). Thanks to
user Karen!
New action`weectl database rebuild-daily NAME` was added to allow the
selective
rebuilding of the daily summaries. Addresses[Issue
#1035](https://github.com/weewx/weewx/issues/1035).
Converted test suites to use[pytest](https://pytest.org).
New Finish translation for the Seasons skin. Thanks to user
iiseppi.
--
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/CAPq0zECai9R%2BqzVWw4NqCQdEF5HNX6PCzCT0%3D0zA1y1fZTOfSQ%40mail.gmail.com
<https://groups.google.com/d/msgid/weewx-user/CAPq0zECai9R%2BqzVWw4NqCQdEF5HNX6PCzCT0%3D0zA1y1fZTOfSQ%40mail.gmail.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 visit
https://groups.google.com/d/msgid/weewx-user/bfdb442d-88c9-4be3-9552-e2b29d7eb9d0%40hillsandlakes.com.
