使用sqlite3包在python中的不同线程之间共享:内存:数据库
我想在 python 中创建一个 :memory: 数据库并从不同的线程访问它.基本上是这样的:
I would like to create a :memory: database in python and access it from different threads. Essentially something like:
class T(threading.Thread):
def run(self):
self.conn = sqlite3.connect(':memory:')
# do stuff with the database
for i in xrange(N):
T().start()
并且所有连接都指向同一个数据库.
and have all the connections referring to the same database.
我知道将 check_same_thread=True 传递给连接函数并共享线程之间的连接，但希望尽可能避免这样做.感谢您的帮助.
I am aware of passing check_same_thread=True to the connect function and sharing the
connection between threads but would like to avoid doing that if possible. Thanks for any help.
更正了一个错字.我最初说让所有连接都指向同一个线程"用线程代替数据库.
corrected a typo. I originally said "have all the connections referring to the same thread" substituting thread for database.
如果不破解 sqlite3 库本身，您就无法重用 :memory: 数据库，因为它保证对每个连接都是独占和私有的.要破解它，请仔细查看 sqlite3 发行版(不是 Python 模块发行版)中的 src/pager.c.也许，最方便的实现方法是让 :memory:00, :memory:something, :memory:okay_hai 等别名到通过一些简单的 C 端映射处理不同的 pPager->memDb 指针.
Without hacking sqlite3 library itself you cannot reuse :memory: database, because it's guaranteed to be exclusive and private for every connection. To hack access to it, look closer at src/pager.c in sqlite3 distribution (not Python module distribution). Maybe, most convenient way to implement this would be make :memory:00, :memory:something, :memory:okay_hai etc. aliases to address different pPager->memDb pointers through some simple C-side mapping.