lots of hype about 'lm-powered-knowledge' and 'memory' at the moment.

however, all the approaches I’ve seen, are file-based - mostly Obsidian + ClaudeCode.

You should build a database instead.

a local, SQLite database, with a simple, explicit schema and full text + vector search baked in - is (imo), the better approach.

I fully open-sourced the database, UI and scripts here: https://github.com/bradwmorris/ra-h_os/

And created a video explaining how it works here and how you can set it up. https://youtu.be/YyUCGigZIZE