title: Saving to disk an in-memory database
body: <p>I made a database through sqlite in c++. </p>
  
  <p>The db has been created in memory (using the ":memory:" parameter insted of a filename), in order to have a very quick behavior.</p>
  
  <p>The database is created by the following lines:</p>
  
  <pre><code>sqlite3* mem_database;
  if((SQLITE_OK == sqlite3_open(":memory:", &amp;mem_database)){
      // The db has been correctly created and
      // I can do some stuff with it.
  }
  sqlite3_close(mem_database);
  </code></pre>
  
  <p>My problem is: how can I write the in-memory database to disk? (through c/c++ of course).</p>
  
  <p>I read something about the ATTACH and DETACH sqlite commands, but I can get them working only with the sqlite interactive shell (not from c/c++ code).</p>
  
  <p>Greets.</p>