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.<p>Sick of people reading your journal? Do your worst, <i>MOM</i>.
I run a self hosted notes application[1] on raspberry pi at home. I have been thinking about moving from .md files to sql. Both seem to have their own pros/cons. With SQLLite, I get easy search, tagging while with .md files I get easy editing and viewing by mapping networked drive.<p>[1]: <a href="https://github.com/quaintdev/pinotes" rel="nofollow">https://github.com/quaintdev/pinotes</a>
HN loves notes applications and I always click through and am almost always disappointed. Am I unusual here in that my notes are not all text? If you look in my notebooks (digital or physical) there are sketches and images on almost every page.
Here is the direct link to the
Bibliothecula project (it might be just me but it was not so easy to find):
<a href="https://github.com/epilys/bibliothecula#tooling" rel="nofollow">https://github.com/epilys/bibliothecula#tooling</a>
FTS is great but it's a solution that's designed to work mostly with the English language. For other languages, with accents and so on, you would probably want to normalise the FTS data first by removing the accents.<p>For Chinese, Arabic and so on you'll need to a custom tokenizer which may or may not be available on your target platform.
Slightly off-topic: where/when does it make sense to "spend" the 5-6 bits in a version 4 (random) UUID to indicate which version and variant it is?
Wow, thanks for documenting the idea, this could be a nice alternative to my tiddlywiki markdown setup. I could do all kinds of queries on my knowledge base. Still I could use grep as well for document counts and lists. It's neat that it's all in one compressed sqlite file - but I can tar ball my markdown directory as well. The only benefit I see is that I can use sql to query my documents and it seems like a step up from org-mode tables by using database tables.<p>It would be nice if there was cgi script that could serve a sorted and paged index with links to the html, md or gmi to a web or/and gemini browser.
Bear Notes, the popular note taking app for Mac, stores data in sqlite for many of the same reasons the author mentions here.<p>Bear organizes with "live folders" based on tags added to the document, powered by sqlite.
IMO <a href="https://roamresearch.com/" rel="nofollow">https://roamresearch.com/</a> offers a more practical way of maintaining notes using graphs.