1) No - multiple stations will still require multiple databases. Weewx and its extensions work with both databases as far as I am aware 2) No - KISS principles would indicate SQLite as being preferable to MySQL, even though I use MySQL 3) Yes - weewx caters for both SQLite and MySQL with no issues - the config is in a single file (weewx.conf) and can be changed at will.
On Monday, 9 January 2017 21:07:33 UTC+2, tempus wrote: > Hi, > > I recently installed weewx using apt-get under Ubuntu 16.04.1 Server. I > then enabled the Simulator for testing while awaiting delivery of a USB > logger for a Vantage Pro2 console. All that went well. Weewx is working > as expected with the default SQLite database. > > The hardware has been used only to host a personal cloud server that is > online 24/7. It has a multi-core processor, plenty of memory, and plenty > of storage space. MariaDB (MySQL-compatible) is installed. I am very > familiar with MySQL, but have never used SQLite. I am wondering whether to > switch to MariaDB before inputting real data. > > 1) Other than network accessibility, does MySQL provide any significant > advantage in weewx applications (maybe with multiple weather stations, > various extensions, or whatever)? > > 2) Other than simpler installation and administration, does SQLite provide > any significant advantage in weewx applications (speed, maybe)? > > 3) I assume apt-get upgrade will work in the future without custom changes > if weewx is reconfigured to use MySQL. Is that true? > > -Bob > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
