On Saturday, April 4, 2020 at 9:24:41 AM UTC-4, Greg Troxel wrote: > > Glenn McKechnie <[email protected] <javascript:>> writes: > > > It's not weewx increasing in CPU usage, it's the CPU usage for > > mariadb. Check on your Synology NAS. > > I wonder if people have tried postgresql. (I'm still on sqlite.) >
greg, we started a postgres adapter years ago. it never made it into weewx core. the weewx column names are mixed case, like outTemp and windSpeed. as i recall, postgres lower-cases everything that is not quoted. so we would need a general way of dealing with case sensitivity that works with mysql, sqlite, and postgres. i'm pretty sure it would not be too difficult for weewx core, but making it general enough to work for search list extensions and cheetah templates could be a problem (i think that is why it never made it into weewx core). if you want to hack on it, make a postgresql adapter in bin/weedb/pgsql.py - follow the pattern in sqlite.py or mysql.py in that directory. m -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/3239f908-b392-4855-807d-36d1da319b8f%40googlegroups.com.
