On Fri, Feb 21, 2020 at 2:37 PM Warren Young <war...@etr-usa.com> wrote: > > On Feb 21, 2020, at 5:20 AM, Wout Mertens <wout.mert...@gmail.com> wrote: > > Queries can go faster, because a query like `where json_extract(json, > > '$.foo') = 'bar'` can first check the layouts to see which ones apply, > > SQLite’s JSON1 extension is a storage and query mechanism, not a run-time > object system. I se that things like json_remove() exist, but my assumption > is that 99.manynines% of the time, objects are stored, retrieved, and queried > without being modified at the SQLite level, if at all. > > Therefore, 99.manynines% of the time, there is only one “layout.”
Hmm, that is not what I meant. The idea is that upon storing the JSON data, the JSON1 extension parses it, extracts the layouts recursively, stores them when they are not known yet, and then only stores the values in the binary format with the layout identifiers. So yes, somewhat more work than storing and retrieving a plain string. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
