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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
