I use [SQLite](https://sqlite.org/index.html) as the database for my personal projects in Python. It is [lightweight](https://sqlite.org/serverless.html), [reliable ...

Foreign key constraints are not enforced by default in SQLite. If you want the database to prevent you from inserting invalid foreign keys, then you must run PRAGMA foreign_keys = 1 to turn ...