jq looks very interesting. I have a simplistic filtering syntax to work with right now, as part of a third-party API definition that my system needs to support, but it doesn't support querying into nested structures. jq looks like just the ticket for that. I'm sure I'll take a look when the time comes to extend my system to support nesting properly.
If I end up using jq with sqlite-as-it-is-now, I'd do it on deserialized JSON values that I've already fetched from sqlite. But I, too, would love to have native json support internally in sqlite, so +1 to this idea: https://www.mail-archive.com/sqlite-users@sqlite.org/msg85934.html something like that seems like its probably a necessary first step to being able to build a JSON index on disk. On Tue, Oct 21, 2014 at 4:29 PM, Nico Williams <n...@cryptonector.com> wrote: > On Tue, Oct 21, 2014 at 2:13 PM, Mike Jarmy <mja...@gmail.com> wrote: > > I could probably use an Entity-Attribute-Value approach to modeling JSON > > Yes. > > > I can sort of work around needing to query embedded data structures like > > lists and json objects, so EAV would more or less work for me. Sqlite's > > flexibility with column types could make the EAV approach befairly > > straightforward, I'll see what I come up with. > > I wish Postgres had an ANY column type for just this reason. > > > But again, the holy grail for me would be to just create a disk-based > index > > of the JSON object for each row -- embedded data structures and all -- > > similar to how Postgres does it. > > > Yes, though I'd like the index to use only some JSON paths, not > necessarily all. > > Either way there would then be a need for support for expressions for > traversing paths in JSON texts. I am partial to jq myself (but I > maintain it, so I would be). > > Nico > -- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users