Python 多连接共享Sqlite 内存数据库

简单的测试代码：

import sqlite3

p = sqlite3.connect("file:memDB1?mode=memory&cache=shared", uri=True)
p.execute('CREATE TABLE tbTest (fld1, fld2)')
p.execute("INSERT INTO tbTest VALUES ('fld1', 'fld2')")
p.commit()
list(p.execute('select * from tbTest '))

q = sqlite3.connect("file:memDB1?mode=memory&cache=shared", uri=True)
q.execute("INSERT INTO tbTest VALUES ('fld3', 'fld4')")
q.commit()

list(q.execute('select * from tbTest '))

执行结果：