SQLite Is a Library of Congress Recommended Storage Format

原始链接: https://sqlite.org/locrsf.html

Hacker Newsnew | past | comments | ask | show | jobs | submitloginSQLite Is a Library of Congress Recommended Storage Format (sqlite.org)12 points by whatisabcdefgh 4 hours ago | hide | past | favorite | 1 comment help alexpotato 22 minutes ago [–] I have always loved SQLite.I have also heard that some firms ban its use.Why?Because it makes it SO easy to set up a database for your app that you end up with a super critical component of your application that looks exactly like a file. A file that can have any extension. And that file can be copied around to other servers. Even if there is PII in that file. Multiply this times the number of applications in your firm and you can see how this could get a little nuts.DevOps and DBA teams would prefer that the database be a big, heavy iron thing that is very obviously a database server. And when you connect to it, that's also very obvious etc etc.I still love SQLite though.reply Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact Search:
相关文章

原文
LoC Recommended Storage Format

Small. Fast. Reliable.
Choose any three.

LoC Recommended Storage Format

SQLite is a Recommended Storage Format for datasets according to the US Library of Congress. Further information:

As of this writing (2018-05-29) the only other recommended storage formats for datasets are XML, JSON, and CSV.

Recommended storage formats are formats which, in the opinion of the preservationists at the Library of Congress, maximizes the chance of survival and continued accessibility of digital content. When selecting recommended storage formats, the following criteria are considered (quoting from the LOC website):

  1. Disclosure. Degree to which complete specifications and tools for validating technical integrity exist and are accessible to those creating and sustaining digital content. A spectrum of disclosure levels can be observed for digital formats. What is most significant is not approval by a recognized standards body, but the existence of complete documentation.

  2. Adoption. Degree to which the format is already used by the primary creators, disseminators, or users of information resources. This includes use as a master format, for delivery to end users, and as a means of interchange between systems.

  3. Transparency. Degree to which the digital representation is open to direct analysis with basic tools, such as human readability using a text-only editor.

  4. Self-documentation. Self-documenting digital objects contain basic descriptive, technical, and other administrative metadata.

  5. External Dependencies. Degree to which a particular format depends on particular hardware, operating system, or software for rendering or use and the predicted complexity of dealing with those dependencies in future technical environments.

  6. Impact of Patents. Degree to which the ability of archival institutions to sustain content in a format will be inhibited by patents.

  7. Technical Protection Mechanisms. Implementation of mechanisms such as encryption that prevent the preservation of content by a trusted repository.

联系我们 contact @ memedata.com