📡 You're offline — showing cached content
New version available!
Quick Access
Tutorials Python from Zero SQLite with Python

SQLite with Python

5 min read
Python's sqlite3 module works without any extra install. Use cursor.execute() with ? placeholders to prevent SQL injection. Call conn.commit() after writes and cursor.fetchall() to read all results.

SQLite Database

import sqlite3

conn = sqlite3.connect("mydb.db")
cur = conn.cursor()

cur.execute("""CREATE TABLE IF NOT EXISTS users
    (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)""")

cur.execute("INSERT INTO users (name, age) VALUES (?,?)", ("Alice", 28))
conn.commit()

for row in cur.execute("SELECT * FROM users"):
    print(row)

conn.close()