2 ms·
How? There's a massive difference in usability and performance with a SQL database and all the data querying and manipulation it provides compared to a ZIP file
by manigandham 8y ago
How? There's a massive difference in usability and performance with a SQL database and all the data querying and manipulation it provides compared to a ZIP file that just straps together a bunch of compressed payloads with a key/value file structure.
The linked page even has a case study of the OpenDocument file format that shows exactly how SQLite is better than a Zip file: https://www.sqlite.org/affcase1.html https://www.sqlite.org/affcase1.html
- tedunangst 8y agoIf you're using SQLite as a pile of files, you're not doing much querying if the compressed data inside. > Newer machines are faster, but it is still bothersome that changing a single character in a 50 megabyte presentation causes one to burn through 50 megabytes of the finite write life on the SSD. That's funny, since Firefox would burn through gigabytes of writing to SQLite. All comes down to quality of implementation.
- manigandham 8y agoThe point is that you don't just use it as a pile-of-files when you have SQL access to the data and instead use a high-level data model. This is not possible at all with ZIP.