SQLite Database with Python — a practical guide to Python SQLite with clear examples you can reuse in real projects.
Python Tutorial Series (61/95). Prefer one article? Read the complete Python tutorial.
Short description
SQLite is file-based and perfect for learning SQL and small apps. Use parameterized queries.
sqlite3 CRUD sketch
import sqlite3
conn = sqlite3.connect('app.db')
cur = conn.cursor()
cur.execute('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)')
cur.execute('INSERT INTO users (name) VALUES (?)', ('Asha',))
conn.commit()
print(cur.execute('SELECT * FROM users').fetchall())
conn.close()