It is a database issue because the column's domain should be an integer.
Any other data type allows for garbage data to exist.
By design, many DB engines reject data that does not match the domain.
---
pablo
On June 12, 2026 00:32:08 John Smith <[email protected]> wrote:
This is fundamentally a formatting issue.
It might manifest as a formatting issue, but it's really a database issue
and a waste of bytes storing whole numbers as decimals.
I do know that the extended schema has lighthing count as REAL.
The defaults are unnecessarily bloated, but I guarantee others on this list
don't want the issue rehashed yet again.
On Fri, 12 Jun 2026 at 11:46, 'John Kline' via weewx-user
<[email protected]> wrote:
This is fundamentally a formatting issue. I have this completely covered
in the extension.
I don’t know how well weewx will play with observations that are integers
(but, like I say, this is about formatting). I do know that the extended
schema has lighthing count as REAL.
('lightning_strike_count', 'REAL'),
On Jun 11, 2026, at 6:01 PM, John Smith <[email protected]> wrote:
Why would a column for lightning strikes not use INTEGER in the first place?
It's not like you can have a half or third of a lightning strike.
On Fri, 12 Jun 2026 at 09:35, 'John Kline' via weewx-user
<[email protected]> wrote:
Please don’t change the database. loopdata formats observations as
specified by a report. The reason for this is, typically, the observation
values written on every loop record are used to update values in a report.
Of course, just like when observations are used in a report, adding .raw
will skip the formatting.
On Jun 11, 2026, at 3:01 PM, John Smith <[email protected]> wrote:
The simplest fix would be to remove the column and then re-add it with the
INTEGER type instead of REAL.
The slightly more complex fix would be to update the column type in your
database by doing something like
ALTER TABLE my_table ADD COLUMN new_col INTEGER;
UPDATE my_table SET new_col = CAST(old_col AS INTEGER);
ALTER TABLE my_table DROP COLUMN old_col;
ALTER TABLE my_table RENAME COLUMN new_col TO old_col;
Although Claude.ai says SQLite columns are dynamically typed, so you could
get away with just doing
UPDATE my_table SET col = CAST(col AS INTEGER);
On Fri, 12 Jun 2026 at 01:00, [email protected]
<[email protected]> wrote:
weewx version 5.3.1
Ive added current.ecolightningcount to the weewx-loopdata ver 3.3.2 program
and it updates OK but it displays 6 decimal places. Ive added various
things in weewx.conf but obviously not correctly
Coulk somebody put me out of my misery and point me in the right direction.
Thanks Phil
--
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/32453638-58fc-4a1b-bf38-85e6bcff50den%40googlegroups.com.
--
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/CAGTinV4d%2Bh78RC82nEbAr2owQEbG3r%2Be3zwS8KPJ_rcYaHYXJQ%40mail.gmail.com.
--
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/D2738456-68BF-4254-984B-386411A99E8F%40johnkline.com.
--
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/CAGTinV51OVgF_%2BFgsPVLbLcUQXyiqvKnfBkaTdFtgE%3DRBvnrkw%40mail.gmail.com.
--
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/FF04048C-0414-465C-84E2-543015C11210%40johnkline.com.
--
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/CAGTinV7QPznu5xEQRWNS8q84nrNk9Gf_2uL2m9Do%2BDB1nboGkQ%40mail.gmail.com.
--
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/19ebb9ab9a0.2848.44b74f35a7a433c111dbfaee4cca1c2d%40hillsandlakes.com.
