3 ms·
I totally understand avoiding proprietary formats, but why write off non-human readable formats? I've been using sqlite for things like this. I figure sqlite
by catalogia 7y ago
I totally understand avoiding proprietary formats, but why write off non-human readable formats? I've been using sqlite for things like this. I figure sqlite is not going anywhere. And in the worst case scenario, if for some reason the software I use to interact with the sqlite db was no longer tenable, I could easily dump my data out of it into a text file.
- solarkraft 7y agoHow is your database structured? One table for everything? Something fancy? How do you use it?
- catalogia 7y agoNothing too fancy, the skeleton of the schema is basically just: Tags(tag_id, tag_name) Files(file_id, file_address) FileTags(file_id,tag_id) That's for organizing files using tags. I can organize notes like this by either putting notes into many text files and tagging them, or by putting notes directly into the DB with another Notes table. I've prioritized the former, since many of my "notes" are actually photographs of whiteboards or other non-text data. Storing textual notes directly in the sqlite database works well too though. To interact with the system, I threw together a quick emacs client and a GUI client. Nothing fancy or pretty yet, but functional enough for my day-to-day use.
- superkuh 7y agoBit flips and other errors kill or make non-flat formats only non-trivally accessible. Anything requiring programatic interpretation is fragile.