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

2023-12-03 Thread Raoul Snyman
On Monday, December 4, 2023 at 2:20:38 AM UTC Cameron D wrote: I don't understand the problem. My MariaDB server is set to *case-sensitive* (file-system and table names). The column names are mainly camel case (using a trimmed down version of the old schema with original names, such as 'inTemp'

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

2023-12-03 Thread Raoul Snyman
On Sunday, December 3, 2023 at 3:32:07 PM UTC Tom Keffer wrote: I'll be merging the V5 branch into the development branch in the next few days, but target the V5 branch for now. Thanks, I'll target V5 for now. As I recall, the "case sensitivity" problem with Postgres is that in order to ac

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

2023-12-03 Thread Raoul Snyman
Hey Matthew, Yeah, I read about the case-sensitivity issues. I am planning to use some look-up tables to get around the issue. A bit of a dirty hack, but hopefully it'll get me what I want :-D -- You received this message because you are subscribed to the Google Groups "weewx-development" gr

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

2023-12-03 Thread 'Cameron D' via weewx-development
I don't understand the problem. My MariaDB server is set to *case-sensitive* (file-system and table names). The column names are mainly camel case (using a trimmed down version of the old schema with original names, such as 'inTemp' and 'rain'). I have a second instance with an ecowitt DB where t

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

2023-12-03 Thread Tom Keffer
Yeah, I'm not going to do that. 3rd party code still wouldn't work. On Sun, Dec 3, 2023 at 8:04 AM Joel Bion wrote: > > Sent from my iPhone > > On Dec 3, 2023, at 7:32 AM, Tom Keffer wrote: > > I'll be merging the V5 branch into the development branch in the next few > days, but target the V5

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

2023-12-03 Thread Joel Bion
Sent from my iPhoneOn Dec 3, 2023, at 7:32 AM, Tom Keffer 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 ev

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

2023-12-03 Thread Tom Keffer
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

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

2023-12-03 Thread Greg Troxel
matthew wall writes: > the schema uses mixed case, and the column names are not consistent > (some are snake_case, some are camelCase). these names are used > directly (case-sensitive), throughout the weewx code, and particularly > in the templates and plots. the problem i encountered when doin

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

2023-12-03 Thread matthew wall
hi raoul! postgres support would be most excellent. i think the biggest obstacle is the case sensitivity of column names. the schema uses mixed case, and the column names are not consistent (some are snake_case, some are camelCase). these names are used directly (case-sensitive), throughout