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
bradwmorris•1h ago
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