Move to sqlite for caches

[pelikhan]

Use SQLite as cache backend, local vector db

https://markus.oberlehner.net/blog/your-own-vector-search-in-5-minutes-with-sqlite-openai-embeddings-and-nodejs

[github-actions]

The title "Move to sqlite for caches" is concise but could benefit from a bit more context. It's good to state the goal, but it doesn’t immediately convey why this change is being proposed.

The body content points to a helpful blog post, which is excellent for providing resources. However, it would be beneficial to briefly explain the rationale for using SQLite as a local vector database – e.g., for offline access, reduced latency, or simplified deployment. Consider adding a sentence or two summarizing the key advantages of this approach.

AI-generated content by issue-reviewer may be incorrect