sqlite3, memory db and multithreading

królewna królewna at ee.pl
Thu Mar 18 13:58:32 CET 2010

The problem is simple: I have multiple threads within one program. At 
least 2 threads have to have access to in-memory sqlite database. It is 
not possible to pass sqlite objects to those threads because an 
exception is rised:

ProgrammingError: SQLite objects created in a thread can only be used in 
that same thread.The object was created in thread id -1219066176 and 
this is thread id -1224475792

Is there any EASY way to use this in-memory db in many threads? Creating 
another connection is not a solution as it creates completely new db 
instead of connecting to the existing one.

Best regards

More information about the Python-list mailing list