SQLite Basics

The SQLite library is a light-weight embedded SQL engine, with a nice DB API compliant Python binding, originally developed by Michael Owens. A newer version, called sqlite3, was added to Python’s standard library in Python 2.5. import sqlite3 db = sqlite3.connect(“database.db”) c = db.cursor() c.execute(“create table mytable (timestamp, size, file)”) for file in os.listdir(“.”): c.execute( “insert into mytable values (?, ?, … Read more