An argument for SQLite

The SQLite project has an article proposing a thought experiment of replacing the zip archive in the Open Document Format, with an SQLite database. It's a good read for those of you who haven't seen it yet and it also does a good job motivating step by step why a database makes sense for document storage. I know that the situation with Joplin isn't exactly comparable, since this article is talking about structured document, whereas Joplin uses (almost) plain text. However, this is a good introduction and there are definitely parallels that can be made.


Interesting, and indeed something to keep when developing an app format as it sometimes makes more sense to use SQLite rather than an archive. I wonder if that could also be applied to complex directories like node_modules. I'm sure there would be benefits to have one, mostly read-only database, instead of millions of small files.

1 Like