What If OpenDocument Used SQLite?
6 days ago
- #OpenDocument
- #FileFormats
- #SQLite
- The article explores the hypothetical benefits of using SQLite instead of ZIP for the OpenDocument Presentation (ODP) format.
- Current ODP files are ZIP archives containing XML files and images, leading to inefficiencies in updates, memory usage, and startup times.
- SQLite could offer atomic updates, reducing the risk of corruption and improving 'File/Save' performance.
- Storing slides individually in SQLite could speed up startup by loading only the first slide initially.
- SQLite's flexibility allows for reduced memory usage by loading only necessary slides.
- Versioning and incremental saves could be implemented more easily with SQLite, enhancing crash recovery.
- SQLite databases can be as compact as ZIP archives and offer better accessibility and query capabilities.
- The article emphasizes that this is a thought experiment, not a critique of the existing ODP format.