Hey Tom,
Thank you for the context.
Ah, interesting SQLite /anomaly/ because IIRC, a *PRIMARY KEY*,**as
defined by SQL ANSI, must uniquely identify the row and must not contain
NULL values (because that would not allow one to uniquely identify the
row.)
Some vendors allow the ability to specify NULL values for a PK (IMO,
kinda weird Use Case). Usually, it's because the model is busted.
Anyway, ignore my ramblings. :)
---
pablo
On 2026-02-23 18:19, Tom Keffer wrote:
Well sure. UNIQUE is not going away, it's just being enforced by the
PRIMARY KEY attribute.
This issue explains: https://github.com/weewx/weewx/issues/1031
On Mon, Feb 23, 2026 at 3:07 PM Pablo Sanchez
<[email protected]> wrote:
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
<https://groups.google.com/d/msgid/weewx-user/bfdb442d-88c9-4be3-9552-e2b29d7eb9d0%40hillsandlakes.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/CAPq0zEDUPN%2Bc_E4_vBt-3wYtcHxjD6u3NZMPoxQd_fDrx0%2BUUw%40mail.gmail.com
<https://groups.google.com/d/msgid/weewx-user/CAPq0zEDUPN%2Bc_E4_vBt-3wYtcHxjD6u3NZMPoxQd_fDrx0%2BUUw%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/73a60ca4-97b4-4f98-a851-76bbdde8b0fc%40hillsandlakes.com.
