Library of Congress Adds SQLite to Its Short List of Recommended Dataset Formats

The US Library of Congress has designated SQLite as a Recommended Storage Format for datasets, placing it alongside XML, JSON, and CSV as one of only four formats blessed for long-term preservation. The designation signals that LoC archivists believe SQLite databases stand a strong chance of remaining readable and intact decades from now.

The selection criteria favor SQLite’s structural strengths: a fully published file format spec, broad adoption across operating systems and devices, no patent encumbrance, no mandatory encryption layer, and minimal external dependencies. A SQLite file is a single self-contained artifact that can be opened with widely available tooling, which matters more to preservationists than backing from a formal standards body.

For engineers, the practical takeaway is that shipping data inside a SQLite container is a defensible archival choice, not just a runtime convenience. It puts the embedded database in the same preservation tier as the plain-text formats it competes with for data interchange, while offering indexing, typed columns, and transactional integrity those formats lack.