News for hackers. Stuff that matters.
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.