Since I prefer for my database to detect invalid foreign keys for me, and since (as we'll see below) the Python's `sqlite3` module will sometimes open transactions implicitly, I run `PRAGMA ...

Using SQLite effectively in Python I use SQLite as the database for my personal projects in Python. It is lightweight, reliable, well-documented, and better than the filesystem for persistent storage.

SQLite is a lightweight, disk-based database that doesn’t require a separate server process and allows accessing the database using a nonstandard variant of the SQL query language. Python provides an ...