4 ms·
SQLite is one of the few file formats that's recommended by the US Library of Congress for archival storage: https://www.loc.gov/preservation/digital/formats/fd
by simonw 5y ago
SQLite is one of the few file formats that's recommended by the US Library of Congress for archival storage: https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml#local https://www.loc.gov/preservation/digital/formats/fdd/fdd0004...
See also this page on the SQLite website (they're understandably very proud of this): https://www.sqlite.org/locrsf.html https://www.sqlite.org/locrsf.html
I think it's a fantastic format for archiving and distributing data.
- rileytg 5y agosqlite also has roots in the us military (navy iirc). this could explain the US govs willingness to adopt.
- tptacek 5y agoThe LOC page explains why they recommend SQLite. https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml https://www.loc.gov/preservation/digital/formats/fdd/fdd0004...
- Banana699 5y agoI honestly love SQLlite, so many things about this database are refreshingly amazing. The lightweight embedded nature, the extreme ubiquity[1], the single-source-file-to-compile idea[2], the gigantic test suite[3], their commitment to stability and backward compatability[4], etc ... Simply a modern marvel of engineering. A thing to put on the next Voyager and send to aliens as a representative of what human minds and hands can do. [1] https://www.sqlite.org/mostdeployed.html https://www.sqlite.org/mostdeployed.html [2]https://www.sqlite.org/amalgamation.html https://www.sqlite.org/amalgamation.html [3] https://www.sqlite.org/testing.html https://www.sqlite.org/testing.html [4]https://www.sqlite.org/lts.html https://www.sqlite.org/lts.html
- euroderf 5y agoAll I'd want is a CLI tool that can dump an SQLite file so that it actually looks like a table (using "|", "-", "+", etc.), and maybe also accept grep-style filter specs (per specified column[s] of course).
- tschan 5y agoThis sounds like an interesting weekend project. Are you saying you can't find anything for this?
- euroderf 5y agoThere is catsql[1] but it barfs in my Python environment. [1]https://github.com/paulfitz/catsql https://github.com/paulfitz/catsql
- aldonius 5y agoyou can get a long way with something like $ echo "<sqlite3 commands / sql queries>" | sqlite3 FILE