SQLite3/Python

Installation

python3 -m venv pysqlite
cd pysqlite
source ./bin/activate
pip install --upgrade pip

Versionstest

Python starten …

import sqlite3
sqlite3.connect(":memory:").execute("select sqlite_version()").fetchall()

Bulkimport

import sqlite3
persons =[
    ('Peter','Koppatz'),
    ('Erhard','Koppatz')
]

con = sqlite3.connect(":memory:")
con.execute('create table person(vorname, nachname)')
con. executemany('insert into person(vorname, nachname) values (?,?)', persons)

Tansaktionen

import sqlite3
import time

t= time.time()
persons =[
    ('Peter','Koppatz'),
    ('Erhard','Koppatz')
]

con = sqlite3.connect(":memory:")
cur = con.cursor()
con.execute('create table person(vorname, nachname)')

cur.execute('BEGIN TRANSACTION')
for chunk in persons:
    con. execute('insert or ignore into person(vorname, nachname) values (?,?)', chunk)
cur.execute('COMMIT')
print(f'\nZeitmessung: {time.time()-t:.3f} Sekunden')