Check out Bookstack https://www.bookstackapp.com
Ask HN: Personal Database Tool?
11–20 of 21 posts
Re: Ask HN: Personal Database Tool?
#12I could imagine a simple cli with S3 or some other key value cloud storage could be used to accomplish this.
Re: Ask HN: Personal Database Tool?
#13Emacs Org-Mode!
To expand:
>dump content (images, notes, quotes, names of movies)
The images I would keep in relevant logs/wikis, or a timestamped/datetree journal (in it's own file, a header, or a subheader - whatever's more suitable/comfortable). I mostly save images for fun and logging purposes though. The notes I would keep under a (tagged) header that it belongs too, or in the datetree diary if it's personal. Same with the quotes. I keep names of movies I should watch under a (tagged) 'media' header in my tasks.org file (my other org files are wiki.org and archive.org, fwiw).
>tag each item with multiple tags ("book" "completed" "5 stars")
Tags are a built-in feature, but for the '5 stars' portion, you can go a step further and assign a key-value property to an item, say 'STARS:' and a value, like '5'.
>search for the content by tag ("show me all books I tagged with 5 stars")
And this would be done by doing a search, a tag search, with this syntax specifically: `+books&+STARS="5"`
It's a very flexible system!
Re: Ask HN: Personal Database Tool?
#14Emacs Org-Mode! To expand: >dump content (images, notes, quotes, names of movies) The images I would keep in relevant logs/wikis, or a timestamped/datetree journal (in it's own file, a header, or a subheader - whatever's more suitable/comfortable). I mostly save images for fun and logging purposes though. The notes I would keep under a (tagged) header that it belongs too, or in the datetree diary if it's personal. Sa…
I'd agree with this suggestion, especially if you're willing to put in a bit of legwork to start and learn some of the basics of org-mode.
To me though, one of the killer features of org-mode (compared to some of the other, SaaS product offerings) is that under the hood it's /just/ a plain-text file. You know (unlike the SaaS stuff) it'll be around for 30+ years. To me, it's incredibly valuable when building my own personal information repo/db to know it'll be around as long as I am. Not contingent on a company to remain around or profitable to keep access to my data.
Re: Ask HN: Personal Database Tool?
#15Emacs Org-Mode! To expand: >dump content (images, notes, quotes, names of movies) The images I would keep in relevant logs/wikis, or a timestamped/datetree journal (in it's own file, a header, or a subheader - whatever's more suitable/comfortable). I mostly save images for fun and logging purposes though. The notes I would keep under a (tagged) header that it belongs too, or in the datetree diary if it's personal. Sa…
do you have a nice workflow for images and files?
and what are the limits to keeping everything in one file? theoretically i see no downside to it.
Re: Ask HN: Personal Database Tool?
#16Emacs Org-Mode! To expand: >dump content (images, notes, quotes, names of movies) The images I would keep in relevant logs/wikis, or a timestamped/datetree journal (in it's own file, a header, or a subheader - whatever's more suitable/comfortable). I mostly save images for fun and logging purposes though. The notes I would keep under a (tagged) header that it belongs too, or in the datetree diary if it's personal. Sa…
Is there any way to use org-mode on mobile? I feel like the best solution would be something where you can take notes on the go too
Re: Ask HN: Personal Database Tool?
#17Emacs Org-Mode! To expand: >dump content (images, notes, quotes, names of movies) The images I would keep in relevant logs/wikis, or a timestamped/datetree journal (in it's own file, a header, or a subheader - whatever's more suitable/comfortable). I mostly save images for fun and logging purposes though. The notes I would keep under a (tagged) header that it belongs too, or in the datetree diary if it's personal. Sa…
Is there any way to use org-mode on mobile? I feel like the best solution would be something where you can take notes on the go too
I use Emacs with Termux on Android. You can use the volume buttons as modifier keys, so it’s not so bad. Other solutions like Orgzly and Beorg exist, but I haven’t tried them personally.
Re: Ask HN: Personal Database Tool?
#18Emacs Org-Mode! To expand: >dump content (images, notes, quotes, names of movies) The images I would keep in relevant logs/wikis, or a timestamped/datetree journal (in it's own file, a header, or a subheader - whatever's more suitable/comfortable). I mostly save images for fun and logging purposes though. The notes I would keep under a (tagged) header that it belongs too, or in the datetree diary if it's personal. Sa…
do you have a nice workflow for images and files? and what are the limits to keeping everything in one file? theoretically i see no downside to it.
What do you mean about the images and files, specifically? If embedding images within an org file, it is super easy, just do ‘[[file://image/path.jpg]]’ and run M-x org-toggle-inline-images (i think that’s the command).
My org files (all of which reside in my agenda directory, ~/org) are divided primarily into archives.org (i keep a datetree log here), wiki.org (bookmarks, notes etc), and tasks.org. With sparse trees, narrowing to subtree etc I tend to keep big monolithic files and just filter for the view I want, though many seem to prefer smaller ones (i find it harder to sync more files and directories though, and I’m unsure of the advantages more files provide).
Re: Ask HN: Personal Database Tool?
#19Earlier quoted context omitted.
do you have a nice workflow for images and files? and what are the limits to keeping everything in one file? theoretically i see no downside to it.
What do you mean about the images and files, specifically? If embedding images within an org file, it is super easy, just do ‘[[file://image/path.jpg]]’ and run M-x org-toggle-inline-images (i think that’s the command). My org files (all of which reside in my agenda directory, ~/org) are divided primarily into archives.org (i keep a datetree log here), wiki.org (bookmarks, notes etc), and tasks.org. With sparse trees…
Thanks for the reply!
So you have all images of all org docs in one folder? Or one folder per org file? The first would be better for refiling across files, the latter better for portability of the org files.
How many lines does your bigger org than have? My main one has 1.5k. My archive (just a year old maybe) has 15k and many org functions become quite slow, even freezing emacs sometimes.
Re: Ask HN: Personal Database Tool?
#20I know this is not the answer you are looking for, but Microsoft Excel (or a spreadsheet program) can help you with this, except images.
However, notes, quotes, movie names etc. can all be listed in a spreadsheet and can be searched, listed, filtered, etc.