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.
