I was looking at the json1 extension and came to know that json_tree
<https://sqlite.org/json1.html#jtree> is implemented as a virtual table.
Does that mean that the json_tree table is stored in memory after the json
is parsed by sqlite?
If so, for querying json data will I be limited by the memory of my
What happens when json_tree is unable to parse all the json rows in the
database, that is the size of the json columns increase the memory on the
Is there any way to measure the size of this table?
> On Apr 20, 2017, at 11:02 AM, Akshat Jiwan Sharma <[hidden email]> wrote:
> Does that mean that the json_tree table is stored in memory after the json
> is parsed by sqlite?
Yes, but only for the row being evaluated.
It sounds like you’re thinking of json_tree creating a database table that contains all the rows of the real table; that’s not how it works. It simply creates a thing that behaves as a table, whose “rows” are the elements of the JSON collection given as a parameter. After that database row is done being evaluated, the virtual table is disposed.