A comment in the documents says that WAL mode may not be set by default in a future release. Has any more thought been given to this? I recently caused a DB to become corrupted by naively creating the Mojo::SQLite object with no parameter to make a simple select call. This currently silently turns on WAL mode. I believe that the owner process then corrupted the DB when it next wrote, not expecting WAL mode. Opening a non-WAL-mode DB with { ReadOnly => 1 } makes the problem obvious when it fails on attempting to convert the DB; { ReadOnly => 1, no_wal => 1 } would have prevented the problem. This was my fault for being lazy, but I would have expected the less intrusive option of not automatically converting the DB to be the safer one.
A comment in the documents says that WAL mode may not be set by default in a future release. Has any more thought been given to this? I recently caused a DB to become corrupted by naively creating the Mojo::SQLite object with no parameter to make a simple select call. This currently silently turns on WAL mode. I believe that the owner process then corrupted the DB when it next wrote, not expecting WAL mode. Opening a non-WAL-mode DB with { ReadOnly => 1 } makes the problem obvious when it fails on attempting to convert the DB; { ReadOnly => 1, no_wal => 1 } would have prevented the problem. This was my fault for being lazy, but I would have expected the less intrusive option of not automatically converting the DB to be the safer one.