From the docs, "The WAL journaling mode uses a write-ahead log instead of a rollback journal to implement transactions. The WAL journaling mode is persistent; after being set it stays in effect across multiple database connections and after closing and reopening the database."
When using 'single shot' access to the database, with no other connections, I see a wal file being created and deleted. Just for my understanding, would it be of advantage to have a second persistent connection just for keeping the wal alive? (I have no real world scenario for this, I just saw this happen and wondered while setting up SQLTools on Sublime for SQLite. It doesn't/can't create a persistent connection) Ingo _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
