Changes between Version 3 and Version 4 of UserDocs/SQLite

Timestamp:

Feb 7, 2018, 3:59:17 AM (6 years ago)

Author:

Jukka Rahkonen

Comment:

--

UserDocs/SQLite

@@ -33 +33 @@
 SQLite supports different journal modes. The default is the rollback journal. Beginning with version 3.7.0 (2010-07-21), a new "Write-Ahead Log" option (WAL) is available. On one hand WAL is significantly faster in most scenarios and provides more concurrency. But on the other hand WAL does not work over a network filesystem, it is not possible to open WAL databases from read-only media ([https://sqlite.org/wal.html SQLite Documentation on WAL]).
 
+Existence of a WAL file means that there are pending transactions. **Do not ever take the data file (.gpkg, .sqlile) at this state as a backup or for delivering data for other users but wait until the WAL file has disappeared**. That may require closing a connection from the software that has done updates.
+
 
 == Performance