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! [PR #1059](https://github.com/weewx/weewx/pull/1059). >> >> -- > 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.
