Directory Directory
Directory
/ multi_threaded_memory_db.py
Created
November 3, 2019 07:02
This is an example demo of how I was able to pass an sqlite3 database in memory between threads.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import sqlite3 | |
| from threading import Thread | |
| import time | |
| conn = sqlite3.connect("file::memory:?cache=shared", uri=True, check_same_thread=False) | |
| conn.execute("PRAGMA journal_mode=MEMORY") | |
| c = conn.cursor() | |
| # s = time.time() | |
| c.execute('CREATE TABLE test (test TEXT, test2 TEXT)') |