Earlier quoted context omitted.
> indexes them in a local SQLite DB. I don't really understand this. I've been in computing for 45 years now. Programs come and go. I store files I want to keep in the most generic format practical. Storing a file in some program's special format is not a good plan for reading it 40 years from now. For photos, I store them as jpgs in folders named after the year. Within those folders, there might be sub-folders named…
SQLite is an ubiquitous and well-tested piece of software that is going to stand the test of time and survive the next twenty years. There are very few pieces of software that I am able to praise like that with a clean conscience; SQLite is definitely one of them though. You might find it worthwhile to read e.g. about its memory allocation strategy, or its testing strategy. Also, I don't think that the image files th…
My timeline is much longer than 20 years. I have family photos going back to the Civil War.
Besides, Wordstar and Wordperfect files used to be ubiquitous. Good luck with those today.
I switched my mail from Outlook to Thunderbird because the former stores the email in some undocumented unreadable binary format. TB stores the mail as text, so I can recover the mail without needing TB. I have mail going back 25 years now. Some of my earlier mail is now lost because, surprise surprise, the mail program no longer works and the data is stored in a proprietary format.
I unzipped all my old file archives a few years back out of concern that some of the old DOS archive software would disappear.