See also CheatSheet/SQLite.
sqlitedict: Simple KV-store whose interface is a Python dictionary.
maxpert/marmot: Multi-Group Raft distributed sqlite3.
Performance
SQLite Pragma Cheatsheet for Performance and Consistency
sqlite-zstd: Row-based compression