Re:SQLite as an Application File Format (2014)
by lxdesk on Saturday June 13, 2020 @02:58PM
(#23511746)
That conflates the use of the schema with the use of the format features. You can, in fact, use your custom in-memory structures and then "slurp it out" to BLOB when you're ready to save.
[ Parent
| on HN ]
Re:SQLite as an Application File Format (2014)
by ori_b on Saturday June 13, 2020 @03:02PM
(#23511785)
Yes. But if you go that way, though, sqlite is just a slow and clunky format compared to, eg, json or protobuf. I doubt that any program out there uses sqlite this way, other than those which realize they painted themselves into a performance corner and hacked around it for compatibility.