title: SQLite WAL-mode, in-memory, database with private cache?
body: <p>I am working on a project which relies on the read snapshot isolation that the WAL journal mode provides in Sqlite.  It uses multiple connections to the same database to allow concurrent readers and a single writer.</p>
  
  <p>For testing, I would like to use an in-memory database, but as far as I can tell, that requires <code>SQLITE_OPEN_SHAREDCACHE</code> (which invalidates the read snapshot isolation guarantee that WAL mode provides).</p>
  
  <p><strong>Is there any way to open multiple connections to an in-memory, WAL mode, SQLite database in private cache mode?</strong></p>
  
  <p>Is there possibly a (pre-existing) VFS solution to this problem?</p>
  
  <p><a href="https://www.sqlite.org/wal.html" rel="nofollow">WAL-mode docs</a></p>