Hacker News new | ask | show | jobs
by Spooky23 39 days ago
Archivists also love formats close to native. SQLite lets the relational relationships be present in a way that csv cannot.
2 comments

That's certainly true. The ability to define table relationships is a major difference from CSV.
Foreign keys are not enforced unless you enable it but only for that connection.