In this thought experiment, the author explores the idea of using SQLite as the basis for the OpenDocument file format, specifically the “ODP” OpenDocument Presentation format. The author highlights the benefits that this change would bring, including smaller file sizes, faster save and startup times, and better memory management. The author emphasizes that this is only a theoretical suggestion and not a criticism of the current OpenDocument design. They also discuss the limitations of the current OpenDocument Presentation format and propose three improvements: replacing ZIP with SQLite, splitting content into smaller pieces, and adding versioning capabilities. The author provides examples of how these changes could enhance the user experience.
https://www.sqlite.org/affcase1.html