#!/usr/bin/python

import sqlite3

con = sqlite3.connect("test.db") con.execute("PRAGMA journal_mode=wal") cur = con.cursor() cur.execute("CREATE TABLE cards (idx INTEGER PRIMARY KEY, weight INTEGER, key TEXT, val TEXT)") for i in range(10**8): cur.execute("INSERT INTO cards VALUES(?, ?, ?, ?)", (i, 1, i, i)) con.commit()