News for hackers. Stuff that matters.
Re:Many small queries are efficient in SQLite by samatman on Tuesday February 16, 2021 @05:31PM (#26159591)
In SQLite, I can have a table with a row which is `flag INTEGER NOT NULL CHECK flag == 0 or flag == 1 DEFAULT 0`

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...

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.