News for hackers. Stuff that matters.
Re:Using sqlite3 as a notekeeping document graph by cartoonworld on Saturday July 03, 2021 @07:35AM (#27720914)
This ranks anywhere from "nerdy humble brag" to "absurdly impractical" on usage, but what an innovative way to get extremely familiar using sqlite3. I like it.

Sick of people reading your journal? Do your worst, MOM.

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.