## Connecting to SQlite database ```py import sqlite3 cone = sqlite3.connect("sampleardes.db") c = cone.cursor() # user the database here cone.close() ``` ## Create table in SQLite execute and commit ```py import sqlite3 cone = sqlite3.connect("sampleardes.db") c = conn.cursor() try: c.execute(\CREATE TABLE companies ID PRIMARY KEY, name VARCHAR(100) UNIQUE NOT NULL, employees INTEGER DEFAULT 0\) except sqlite3.OperationalError as e: print("sqlite error:", e.args[0]) # table companies already exists conn.commit() conn.close() print("done") ``` ## Insert data into SQLite database ```py import sqlite3 conn = sqlite3.connect("sample.db") c = conn.cursor() my_company = "Acme" try: c.execute(\INSERT INTO companies (name) VALUES(?)\, (my_company,)) except sqlite3.IntegrityError as e: print("sqlite error: ", e.arg[0]) # column name is not unique conn.commit() companies = [ ("Foo", 12), ("Bar", 7), ("Moo", 99), ] try: sql = \INSERT INTO companies (name, employees) VALUES (?,?)\\r c.executemany(sql, companies) except sqlite3.IntegrityError as e: print("sqlite error: ", e.args[0]) # column name is not unique conn.commit() conn.close() print("done") ``` UPDATE works quite similar, but it might have a WHERE clause.