title: Accessing a sqlite database with multiple connections
body: <p>I want to access the same SQLite database from multiple instances.</p>
  
  <p>I tried that from two Python shells but didn't get really consistent results in showing me new entries on the other connection. Does this actually work or was is simply a fluke (or a misunderstanding on my side)?</p>
  
  <p>I was using the following code snippets:</p>
  
  <pre><code>&gt;&gt;&gt; import sqlite3
  &gt;&gt;&gt; conn = sqlite3.connect("test.db")
  &gt;&gt;&gt; conn.cursor().execute("SELECT * from foo").fetchall()
  &gt;&gt;&gt; conn.execute("INSERT INTO foo VALUES (1, 2)")
  </code></pre>
  
  <p>Of course I wasn't always adding new entries.</p>