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.
Enjoy!
5 Likes
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