I find something like org-roam or denote to be the best trade-off. Roam: Plain text, sqlite database you can delete/generate whenever, simple small codebase.

I find something like org-roam or denote to be the best trade-off. Roam: Plain text, sqlite database you can delete/generate whenever, simple small codebase. Denote: Based on grep, no database, simple filename based system, can use any filetype.