Re:SQLite Is a Library of Congress Recommended Storage Format
by Spooky23 on Wednesday May 06, 2026 @11:06PM
(#48044977)
Archivists also love formats close to native. SQLite lets the relational relationships be present in a way that csv cannot.
Re:SQLite Is a Library of Congress Recommended Storage Format
by akihitot on Wednesday May 06, 2026 @11:24PM
(#48045075)
That's certainly true. The ability to define table relationships is a major difference from CSV.
Re:SQLite Is a Library of Congress Recommended Storage Format
by b40d-48b2-979e on Thursday May 07, 2026 @09:47AM
(#48049403)
Foreign keys are not enforced unless you enable it but only for that connection.
The specification is publicly available
- It is widely adopted - It is likely to remain readable in the future - It has little dependency on specific operating systems or services - It carries low patent risk
From the perspective of long-term continuity, avoiding dependence on any particular company or service is extremely important.