SQLite WAL

[jtpereyda]

I just learned about Write-Ahead Logging (WAL) in SQLite https://sqlite.org/wal.html

This reminded me of how we stopped writing every log, and instead write the log file after every test case. This was done to reduce time waiting on disk writes, IIRC. But there is a tradeoff -- the SQLite database does not update within a test case, so our GUI doesn't show individual steps progressing within one test case. I wonder if WAL could allow us to do more writes with a smaller time penalty. We'd probably need to experiment.