title: Can two processes access in-memory (:memory:) sqlite database concurrently?
body: <p>Is it possible to access database in one process, created in another?
  I tried:    </p>
  
  <p><strong>IDLE #1</strong></p>
  
  <pre><code>import sqlite3
  conn = sqlite3.connect(':memory:')
  c = conn.cursor()
  c.execute("create table test(testcolumn)")
  c.execute("insert into test values('helloooo')")
  conn.commit()
  conn.close()
  </code></pre>
  
  <p><strong>IDLE #2</strong></p>
  
  <pre><code>import sqlite3
  conn = sqlite3.connect(':memory:')
  c = conn.cursor()
  c.execute("select * from test")
  </code></pre>
  
  <p><strong>Error:</strong></p>
  
  <pre><code>Traceback (most recent call last):
    File "&lt;pyshell#5&gt;", line 1, in &lt;module&gt;
      q = c.execute("select * from test")
  sqlite3.OperationalError: no such table: test
  </code></pre>