Python Projects & Skills / The web and automation

Lesson 22 of 28

SQLite databases

SQLite stores data in a single file and comes built into Python. Always use ? placeholders for values, never string formatting, to avoid SQL injection.

import sqlite3
db = sqlite3.connect("app.db")
db.execute("CREATE TABLE IF NOT EXISTS users (name TEXT)")
db.execute("INSERT INTO users VALUES (?)", (name,))
db.commit()