Re:Many small queries are efficient in SQLite
by Dylan16807 on Wednesday February 17, 2021 @02:09AM
(#26163589)
That's a feature of the database engine, not the file format. You could attach a similar database engine to a zip backend.
Re:Many small queries are efficient in SQLite
by samatman on Wednesday February 17, 2021 @02:50AM
(#26163795)
This is an asinine objection.
Re:Many small queries are efficient in SQLite
by Dylan16807 on Wednesday February 17, 2021 @03:05AM
(#26163881)
I have a better one, if you want it.
A configuration like that comes from the program using sqlite. Just adding sqlite into a system doesn't set up any data formatting like that. Sqlite itself gives you a blank canvas. And a blank canvas is not much of a data format.
Re:Many small queries are efficient in SQLite
by samatman on Wednesday February 17, 2021 @05:19PM
(#26172587)
You're wrong about this.
The SQLite data format includes the schema, in plain ASCII. This self-documenting nature makes it an excellent data format, I've taken advantage of it numerous times in making use of SQLite-based application file formats.
SQLite is put forth as a basis for an application file format, and by definition it must be sufficiently flexible to accommodate any application. But by including the schema, it is self-documenting as to what the structure is, which ZIP isn't and can't be. QED.
Surely this is more structure than a ZIP file, which is merely a way of compressing a directory of files into a single entity, can provide?
Sure the INTEGER part doesn't really do anything...