Get the latest tech news
What If OpenDocument Used SQLite?
le format, and specifically the "ODP" OpenDocument Presentation format, were built around SQLite. Benefits would include: Note that this is only a thought experiment.
Perhaps for this reason, the OpenOffice forks make periodic backups of their in-memory documents so that users do not lose all pending edits when the inevitable application crash does occur. In the previous sections, we have seen how moving from a key/value store implemented as a ZIP archive to a simple SQLite database with just three tables can add significant capabilities to an application file format. Some readers might be reluctant to consider SQLite as an application file format because they have been inculcated with the idea that all SQL database schemas must be factored into Third Normal Form (3NF) and store only small primitive data types such as strings and integers.
Or read this on Hacker News
