title: VACUUM database and WAL mode
body: <p>I have SQLite database in <code>WAL</code> mode. Each time I perform a <code>VACUUM</code> on the database, the journal mode reverts to <code>DELETE</code> next time I reconnect. </p>
  
  <p>For example:</p>
  
  <pre><code>PRAMGA journal_mode; -- returns wal
  VACUUM;
  PRAGMA journal_mode; -- returns wal
  -- disconnect then reconnect
  PRAGMA journal_mode; -- returns delete
  </code></pre>
  
  <p>Behaviour observed in SQLite 3.7 but appears to be fixed in 3.8.</p>