mwall <mw...@users.sourceforge.net> writes: > we started a postgres adapter years ago. it never made it into weewx core.
Sorry -- I use a lot of programs and my memory was that weewx supported postgres. I have used it for various things over the years including one project that had frequent crashes due to laptop batteries dying and it did amazingly well in terms of robustness. > 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. Interesting - I am guessing that postgres is compliant with the SQL specs, but making a different within-spec choice. > 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. I have put your text into my todo list. But it's large :-( Thanks for taking the time to straighten me out. -- 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/rmio8s7atmi.fsf%40s1.lexort.com.
