The US Library of Congress recommends SQLite for the preservation of data — not other relational database systems. I am not surprised since SQLite reads and writes data to files without the need of a server. SQLite is low maintenance and has not changed the mechanism used to read and write data since released on 08/17/2000 following SQL-92 standards. The latter means that data written quarter of a century ago can still be read today without errors and it would most likely be read without errors decades from now.
Read more.
- https://sqlite.org/locrsf.html
- https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml#local
- https://www.loc.gov/preservation/resources/rfs/data.html
- https://news.ycombinator.com/item?id=48042434
This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.
