4 ms·
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.
by cartoonworld 5y ago
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.
- epilys 5y agoThank 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.
- bloopernova 5y agoIt'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.
- grlass 5y agoIndeed, 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 https://github.com/org-roam/org-roam-server>
- cartoonworld 5y agoNo, thank you. I had no idea indexing could be used this way. Very cool find.