title: How can I synchronize to disk SQLite database with PRAGMA synchronous=OFF
body: <p>I need a very fast SQLite database acces. Setting parameters this way:</p>
  
  <pre><code>PRAGMA synchronize = OFF
  PRAGMA jorunal_mode = MEMORY
  </code></pre>
  
  <p>makes the speed to be enough for my project.
  These settings makes SQLite to leave synchronization with database file in the hands of operating system.
  But there are a few cases, some certain inserts, after which I must be <strong>sure</strong> that the data was written to the disk.</p>
  
  <p>Is there any way I can force SQLite to write all data (waiting in memory journal) to disk?</p>
  
  <p>Thanks.</p>