python 内存数据库,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 '))

执行结果：