Test SQLite handling simultaneous connections

test.py

# A simple test of SQLite's ability to handle simultaneous connections.
# Result: no problem, DB content at end of test is correct.
# Note: by default, SQLite seems to sync. the disk on .commit(), so the
# test below will grind a physical disk for a long time.  The DB path
# used below is a RAM disk, execution is acceptably fast on that.

import multiprocessing
import sqlite3

DB = "/home/tbrown/r/test.db"


def do_some(n):
    con = sqlite3.connect(DB)
    cur = con.cursor()
    for i in range(n * 1000, n * 1000 + 10):
        cur.execute("insert into test (comment) values (?)", ["At %d" % i])
    con.commit()
    con.close()


if __name__ == "__main__":

    con = sqlite3.connect(DB)
    cur = con.cursor()

    cur.execute("create table test (test integer primary key, comment text)")
    con.commit()
    con.close()

    with multiprocessing.Pool(16) as p:
        p.map(do_some, range(1000))