sqlite is also easier to backup. All its state is held in a single,
regular, file.
I've been using it for 10 years and 200 MB of data with no issues.
The big advantage of MySQL over sqlite is with multi-user, high-transaction
throughput. That's not applicable in the weewx context.
-tk
On Mon, Jan 9, 2017 at 11:07 AM, 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.
>
--
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.