Hacker News new | ask | show | jobs
by theandrewbailey 494 days ago
> The key is not to use any code that won't be supported in 40 years. So that means no databases.

A database could help resolve your search problems. Postgres has been around in some form for over 40 years and has never been as popular as it has been now. It has a good shot of still being around and runnable in some form in 40 years, I think. It has full text search, and even trigrams for fuzzy search.
1 comments
mark_mcnally_je 494 days ago
Yes I've thought a bit more about this topic and am actually writing up a response to my own post - Database are probably ok if you take a raw .sql backup; which is essentially plain text, or at least will be viewable in some form in the future.
link
f30e3dfed1c9 494 days ago
https://sqlite.org/ "The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through the year 2050." Doubt you can do better than that.
link