Dr. Richard Hipp himself outlined a few more limitations of WAL mode in a recent paper. https://www.vldb.org/pvldb/vol15/p3535-gaffney.pdf https://www.vldb.org

Dr. Richard Hipp himself outlined a few more limitations of WAL mode in a recent paper. https://www.vldb.org/pvldb/vol15/p3535-gaffney.pdf https://www.vldb.org/pvldb/vol15/p3535-gaffney.pdf “To accelerate searching the WAL, SQLite creates a WAL index in shared memory. This improves the performance of read transactions, but the use of shared memory requires that all readers must be on the same machine [and OS instance]. Thus, WAL mode does not work on a network filesystem.” “It is not possible to change the page size after entering WAL mode.” “In addition, WAL mode comes with the added complexity of checkpoint operations and additional files to store the WAL and the WAL index.”