Re:Using sqlite3 as a notekeeping document graph
by epilys on Saturday July 03, 2021 @07:56AM
(#27721011)
Thank you :) It was just a demo on how I found sqlite's indexing useful for something I thought would require an extension or external tools. I don't keep notes myself, I was working with full text search because I was indexing my PDFs. I hope it's useful for people that do keep notes, however.
Re:Using sqlite3 as a notekeeping document graph
by bloopernova on Saturday July 03, 2021 @08:04AM
(#27721046)
It's very cool, I enjoyed reading the post describing it!
Personally I use Emacs, org-mode, and org-roam for Zettel-style links between documents. Org-roam uses sqlite to store its links and index, but documents remain in plain text .org files.
Re:Using sqlite3 as a notekeeping document graph
by grlass on Saturday July 03, 2021 @04:42PM
(#27724740)
Indeed, thank for the post!
+1 on org-roam, and may I add org-roam-server, which visualises that graph in the browser very nicely, in an interactive way: <https://github.com/org-roam/org-roam-server>
Re:Using sqlite3 as a notekeeping document graph
by cartoonworld on Saturday July 03, 2021 @08:01PM
(#27726067)
No, thank you.
I had no idea indexing could be used this way. Very cool find.
Sick of people reading your journal? Do your worst, MOM.