Module {{{sqlite3}}} is part of the python standard library. ==== Examples {{{c import sqlite3 con = sqlite3.connect("file.db") con2 = sqlite3.connect(":memory:") # in memory only cur = con.cursor() cur.execute(sql) vals = ('Mr Flibble','today','Fry everybody with hex vision') sql = '''INSERT INTO mytable(name,date,plan) VALUES (?,?,?)''' cur.execute(sql,vals) con.commit() print(cur.lastrowid) vals = ('Mr Flibble','today','Fry everybody with hex vision',42) sql = '''UPDATE mytable SET name = ?, date = ?, plan = ? WHERE id = ?''' cur.execute(sql,vals) con.commit() sql = '''SELECT name, date, plan FROM mytable''' cur.execute(sql) rows = cur.fetchall() for row in rows: print(row) sql = '''DELETE FROM mytable WHERE name = ?''' vals = ('Mr Flibble',) cur.execute(sql,vals) con.commit() }}}%TIME=1617722413