News for hackers. Stuff that matters.
Re:What If OpenDocument Used SQLite? by SQLite on Thursday November 02, 2017 @05:32PM (#15614466)
> I don't know why you think it's going to be magically simplified by changing the storage method.

Because ZIP is a key/value store and SQLite is relational.

(Later:) Here is a slide comparing SQLite to ZIP from a talk I'm scheduled to give on Monday: https://sqlite.org/tmp/sqlite-v-zip.jpg

Both SQLite and ZIP will store files and both are well-established open formats with a trillion instances in the wild.

SQLite does everything ZIP does but also gives you transaction, a rich query language, a schema, and the ability to store small (1-8 byte) objects and to translate objects into the appropriate byte-order for the reader.

There are no comments on this comment yet.