3 ms·
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
by millstone 6y ago
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.
- mb7733 6y agoI'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'?