title: How do I open an in-memory database file into sqlite3
body: <p>I'm on a system with no access to disk. My C program has in memory the contents of a valid, small, sqlite3 file (received over the network). I would like to use sqlite3's C API to open and access this file (read-only is fine).</p>
  
  <p>How do I do this? I know I can create an empty in-memory database with </p>
  
  <p><code>sqlite3_open(":memory:", &amp;foo)</code></p>
  
  <p>but is there any way to open my existing db? I don't have the privileges to create a ram disk, but perhaps something along those lines? Thanks.</p>