> > 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 >>> <https://groups.google.com/d/msgid/weewx-user/32453638-58fc-4a1b-bf38-85e6bcff50den%40googlegroups.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/CAGTinV4d%2Bh78RC82nEbAr2owQEbG3r%2Be3zwS8KPJ_rcYaHYXJQ%40mail.gmail.com >> <https://groups.google.com/d/msgid/weewx-user/CAGTinV4d%2Bh78RC82nEbAr2owQEbG3r%2Be3zwS8KPJ_rcYaHYXJQ%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/D2738456-68BF-4254-984B-386411A99E8F%40johnkline.com >> <https://groups.google.com/d/msgid/weewx-user/D2738456-68BF-4254-984B-386411A99E8F%40johnkline.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/CAGTinV51OVgF_%2BFgsPVLbLcUQXyiqvKnfBkaTdFtgE%3DRBvnrkw%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CAGTinV51OVgF_%2BFgsPVLbLcUQXyiqvKnfBkaTdFtgE%3DRBvnrkw%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/FF04048C-0414-465C-84E2-543015C11210%40johnkline.com > <https://groups.google.com/d/msgid/weewx-user/FF04048C-0414-465C-84E2-543015C11210%40johnkline.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/CAGTinV7QPznu5xEQRWNS8q84nrNk9Gf_2uL2m9Do%2BDB1nboGkQ%40mail.gmail.com.
