[sqlite] json question

[rene]

Hello,

I have a big json string in an sqlite memory database.
The json string contains also arrays like:

"arrayname" : [
  {
    "name" : "unique_name",
    "id" : 1,
    ...
  },
  ..
]

Currently I create my own index on "name" and "id" and get the values with:

json_extract(db.json,'$.arrayname[index].name')
json_extract(db.json,'$.arrayname[index].id')
json_extract(db.json,'$.arrayname[index]....')

Question 1: Is it possible to create an index on "name" and "id" inside
sqlite

Question 2: Can I speed up the reading of the values.


Thank you
René




--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users