sqlite 3.22.0 added the ability to read from WAL mode databases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory.
Even though the wiki page states that WAL does not work over a network filesystem, I am able to use WAL over a network filesystem when using sqlite 3.22.0 as long as the respective -shm and -wal files exist. (This may or may not work with earlier versions.) Could someone clarify if this is intended or may result in database corruption? (I am only reading from the database on the remote host) Is there some way to force the -shm and -wal files to always be present? Best regards Leonard PS: The details of the network filesystem mount: hostname:/home/data on /home/hostname type nfs4 (ro,relatime,vers=4.1,rsize=1048576,wsize=1048576,namlen=255,hard,proto=tcp,port=0,timeo=600,retrans=2,sec=sys,clientaddr=IPADDR,local_lock=none,addr=IPADDR) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
