title: Writing in SQLite multiple Threads in Python
body: <p>I've got a sqlite3 database and I want to write in it from multiple threads. I've got multiple ideas but I'm not sure which I should implement.</p>
  
  <ol>
  <li>create multiple connection, detect and waif if the DB is locked</li>
  <li>use one connection and try to make use of Serialized connections (which don't seem to be implemented in python)</li>
  <li>have a background process with a single connection, which collects the queries from all threads and then executes them on their behalft</li>
  <li>forget about SQlite and use something like Postgresql</li>
  </ol>
  
  <p>What are the advances of these different approaches and which is most likely to be fruitful? Are there any other possibilities?</p>