Databases in Python

title: Databases in Python — sqlite3 & Patterns
published: false
tags: [python, databases, sqlite]

This post introduces using sqlite3 for lightweight storage and outlines
patterns for connections, parameterized queries, and migrations.

Example:

import sqlite3
conn = sqlite3.connect('app.db')
with conn:
    conn.execute('CREATE TABLE IF NOT EXISTS users(id INTEGER PRIMARY KEY, name)')
    conn.execute('INSERT INTO users(name) VALUES(?)', ('alice',))

When you outgrow SQLite, consider Postgres and connection pooling.