Re: [weewx-development] Re: PostgreSQL support, which branch to target?

[Joel Bion]

Sent from my iPhone On Dec 3, 2023, at 7:32 AM, Tom Keffer <tkef...@gmail.com> wrote: I'll be merging the V5 branch into the development branch in the next few days, but target the V5 branch for now. As I recall, the "case sensitivity" problem with Postgres is that in order to achieve case-insensitivity, it converts everything to lower case, including column names. When WeeWX starts up, it reads the schema from the database itself. So, something that started out like "outTemp" becomes "outtemp". Then if some code needs the outside temperature to calculate, say, dewpoint, it can't find it because Python string comparisons are always case-sensitive. In the intervening years, perhaps Postgres has added a switch to prevent this. Don't know. To work around it in the WeeWX code would require either that all string comparisons involving SQL types become case-insensitive, which would break countless 3rd party extensions, or the code that reads the schema from the database would have to be changed to read it from metadata, or someplace else.  There are ways around the problem. But, it's a biggish project. I'd be mighty grateful if someone took it on. -tk Detail: Postgres can accept mixed case table names but it requires always quoting them, per https://stackoverflow.com/questions/20878932/are-postgresql-column-names-case-sensitive#20880247 On Saturday, December 2, 2023 at 7:46:32 PM UTC-8 Raoul Snyman wrote: Hello, I just came across WeeWX a week or so ago when I was looking for some open source Linux-based software to pull data from my AcuRite weather station. Fantastic project. I am working on adding support for PostgreSQL (my database of choice), and I wanted to check which branch I should be targeting. I see the V5 branch, which seems to be the future of WeeWX, but the docs specify targeting the "development" branch. Thanks! -- 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 weewx-development+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/9af547f0-449a-4c79-96b4-2f3559359232n%40googlegroups.com. -- 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 weewx-development+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/F3F5D7DF-64EE-4019-993A-FA510EA162D3%40gmail.com.