Re: Is it possible to dump a sqlite db that has an associated -wal file?
"Keith Medcalf" <[email protected]> Sun, 16 Feb 2020 13:34:48 -0700
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Organization | This Side Up |
| Message-ID | <[email protected]> |
On Sunday, 16 February, 2020 10:25, Richard Hipp <[email protected]> wrote: >> Why the database can not be read by another sqlite3 session when the >> corresponding -wal file exists? Thanks. >Because Firefox uses "PRAGMA locking_mode=EXCLUSIVE;" Perhaps on some platforms, but Firefox 73.0.0 on Windows 10 18636.657 does not -- or if it does, then it doesn't work properly as I can still read/write the various database files while Firefox is running. However, when I open a database and set locking_mode=exclusive then connection to the same database cannot access the database. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users