3 ms·

WAL isn't the footgun, SQLite over network attached storage is. Additional files are not a problem. If you need cross-DB file ACID you can just turn off WAL mod

• bruce511 2y ago
  >> WAL isn't the footgun, SQLite over network attached storage is I agree that using SQLite over a network is not a good idea. But people do do that, and it works tolerably well. On most networks it'll work just fine, especially if writes are sparse. The point of defaults is that they should cover the "widest range". By all means read the docs, and choose to use Wal. But that's an action you take and understand. The point of articles like this though is to help alert people to the settings that exist. You should always read the docs and apply them to your context before using any setting.
  • jklowden 2y ago
    It’s unreliable on any network for good reason: SQLite relies on the kernel for state information on the file system. Two machines sharing one file over a network have two unsynchronized versions of that state. One machine’s write does not update the other’s in-kernel image.