SQLite

https://simonwillison.net/tags/sqlite/

Optimizations

SQLite performance tuning

Towards Inserting One Billion Rows in SQLite Under A Minute - blag

https://github.com/avinassh/fast-sqlite3-inserts

https://stackoverflow.com/questions/52142645/how-to-improve-sqlite-insert-performance-in-python-3-6

Data

• GitHub - asg017/sqlite-lines: A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.)

Cross Database Joins

• Cross-database queries in SQLite (and weeknotes)

Vector Search

• Hybrid full-text search and vector search with SQLite | Alex Garcia’s Blog