GitHub

2021-10-using-sqlite-in-python.md

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 ...
GitHub

2021-10-using-sqlite-in-python.md

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 ...