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

DuckDB vs SQLite: Features, Performance, and How to Choose the Right Database

Overview: SQLite is suitable for apps that require reliable storage and small but frequent updates.DuckDB can handle large ...