Just as a referenced for “second brain” local apps I suggest to look at dendron. Dendron is no longer being maintained but it still works and I use it for my notes since I adopted it a few year ago, it’s pretty great for programmers since it works on top of VS Code.