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 the column names are mixed camel and snake (I took standard CamelCase name and added identifying suffixes with an underscore). And, of course, all the archive table names are snake with possible camel suffixes, matching the original column name. I have not noticed any problems so far. My systems are all run on Debian Linux - if the issue is only a problem of compatibility with servers running on ms-windows or macs then that could be just declared as a known limitation.
On Sunday, 3 December 2023 at 11:45:48 pm UTC+10 matthew wall wrote: > 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 the weewx code, > and particularly in the templates and plots. the problem i encountered > when doing a half-hearted attempt at postgres support (almost 10 years > ago!) was the case sensitivity of the database. i seem to recall issues > mapping the mixed-case names into postgres (and also mysql on windows? or > maybe mysql with a case-sensitivity option enabled?) queries. > > anyway, from a development point of view, V5 is stable enough that you are > pretty safe to target that branch. most of the changes now are packaging > and bugfixes as we get ready for a release. the core has been pretty > stable for awhile. > > but i defer to tom - he might want your changes to go through the > development branch before hitting V5. > > 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/07b03780-9a3c-4738-b6cb-376996343916n%40googlegroups.com.
