4 ms·
It is well possible to capture complex structures in a set of tables. For example, the fossil SCM uses sqlite to store file contents, commit history, deltas and
by sriku 6y ago
It is well possible to capture complex structures in a set of tables. For example, the fossil SCM uses sqlite to store file contents, commit history, deltas and metadata, issue tickets, user access info, custom ticket formats if any, and wiki documentation all in a single file, driven by a single executable. Most applications don't have more complex structure than that. Furthermore, parts of the application can pull the exact bits they need at a given time instead of having to parse all the data, since sqlite can run full fledged queries. Total win IMO.
The argument for this has already been made very well by the sqlite creator.
https://sqlite.org/appfileformat.html https://sqlite.org/appfileformat.html
- deleted 6y ago[deleted]