Re: [weewx-user] weewx-loopdata program

Thu, 11 Jun 2026 16:35:57 -0700

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.

Reply via email to