Yeah I don’t disagree. Let’s not over-fixate on SQLite. As @mudasobwa mentioned above, it could be a different kind of a DB (graph in his case). My broader point is: why not use something that can serve your storage and querying needs from the get go instead of inevitably reinventing a mini DB engine two years in the future, based on an idealistic hand-wavy “let’s have less dependencies” vibe?
Additionally, I don’t see the “NIF adapter” being any sort of a negative point here, especially with high-quality LLM agents in the equation. You can link your Elixir LSP code with a library written in almost any programming language in an hour.
