Many small queries are efficient in SQLite

Re:Many small queries are efficient in SQLite by millstone on Tuesday February 16, 2021 @06:12AM (#26152872)

I hope to make the modest point that, if you package your data in a SQLite file or a zip file, then you have both packaging and data problems.

MyCoolSQLApp may read and write a SQLite file with its own schema, but it can't handle an arbitrary SQLite file. Likewise MyCoolZipApp can't handle an arbitrary zip file.

[ Parent | on HN ]

Re:Many small queries are efficient in SQLite by mb7733 on Wednesday February 17, 2021 @11:53PM (#26175989)

I'm not clear on the point here. You can make an application that handles arbitrary SQLite files, (for example: the SQLite shell, or a GUI database broswer), or you can make an application that only uses SQLite files with certain content/schema. Does this mean that SQLite does or does not define a file format?

If not, what do you call the specification of how data is stored in a SQLite file besides a 'file format'?

[ Parent | on HN ]