SQLite

“A decade of SQLite use has also made me comfortable with the underpinnings along with a preference for the batteries-included functionality(.e.g wiki, issues, and notes).”

“I used SQLite because it makes a lot of sense to use as an application file format[1], i.e. as an alternative to writing directly to the filesystem.”

“SQLite + FTS5 for memory instead of a vector DB. Handles retrieval well for personal-agent scale, zero infrastructure overhead.”

“I've started using SQLite years ago for its use of a single file to store data.”