sqlite-test.py

import os.path
import sqlite3

db_file = 'test2.db'

if not os.path.exists(db_file):
    conn = sqlite3.connect(db_file)
    conn.execute("create virtual table syslog using fts3(logs)");

conn = sqlite3.connect(db_file)

with open("20k.log") as fh:
    for line in fh:
        # print(line)
        line = line.replace("'", "''")
        sql = "insert into syslog values('" + line + "')"
        # print(sql)
        conn.execute(sql)
#        conn.commit()

conn.commit()