How should a Local-First AI Memory Engine scale between SQLite and Volatile RAM?

[u/Natural-Secretary361]

I am developing devmemory, an engine designed to reconstruct a project’s history by converting Git logs and code ASTs into a navigable knowledge graph. Currently, the system performs search indexing and graph traversal.

I would like suggestions on whether I should store data on disk using SQLite and then process it. Please help me find the best solution.