It's not generally a good idea to do this. There are two reasons: 1. There is a lot of traffic between the SQLite engine and the remote file system. Adding a network link can dramatically reduce performance. 2. More importantly, to achieve ACID properties, SQLite assumes that a fsync() call means all data was written to hard store, or will soon be written, before any subsequent writes. By contrast, in a network connection, the order of packet arrival is not guaranteed. The result is that getting fsync() to work over a network is hard. Sometimes, in the interest of performance, corners are cut. To be sure, they are corner cases, but they do happen.
Net-net: as Rainer says, if your goal is data integrity, you're better off doing proper backups. If your goal is remote database access, you're better off using MySQL. Hope that helps. On Fri, Mar 18, 2022 at 10:49 AM Wayne <[email protected]> wrote: > Instead of running the weewx database my Raspberry Pi 4 microSD card I'd > like to relocate it to a shared drive on a Synology NAS. This is mainly to > take advantage of the data redundancy of the NAS. > > 1. Is this simply a matter of changing SQLITE_ROOT to point to the new > location? > 2. Any reason to not use a remote host in this manner? > > An alternate solution is to periodically backup the file weewx.sdb but I > just prefer having the database on the RAID storage device in the first > place. > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/d67ef9df-3e5e-488a-bc9a-39dc2f8881bcn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/d67ef9df-3e5e-488a-bc9a-39dc2f8881bcn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBTCstggfL3j8e%3D1%2BaZmtO7bM2gVHDHPAkw1TT7KUWDTg%40mail.gmail.com.
