It appears that neither Unqlite nor sculejs supported disk-based indexing of arbitrary JSON data, which is the use case I'm looking at here (they both look cool though). I already have something very similar to sculejs, but I currently keep all the JSON documents in RAM, which is not going to work for me indefinitely.
I could probably use an Entity-Attribute-Value approach to modeling JSON http://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model 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. 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. On Tue, Oct 21, 2014 at 2:47 PM, Nico Williams <n...@cryptonector.com> wrote: > On Tue, Oct 21, 2014 at 10:14 AM, Dominique Devienne > <ddevie...@gmail.com> wrote: > > On Tue, Oct 21, 2014 at 3:38 PM, Mike Jarmy <mja...@gmail.com> wrote: > > > >> Has there been any discussion of adding JSON indexing to sqlite, > similar to > >> the way Full Text Search and R-Tree are available? > >> > >> Postgres 9.4 beta has a very nice facility for creating indexes on json > >> column types: > > > > Would be nice, true. But then you need some kind of XPath or XQuery for > > JSON on the query side. > > There are a variety of suitable XPath-like libraries for JSON. > > It wouldn't be hard to implement user-defined functions (and virtual > tables) to use such a library. It'd have to encode/parse JSON texts > all the time when interfacing with SQLite3, which is a bit suboptimal. > Something could be done to improve that, but it'd be an optimization. > > The only thing SQLite3 really needs here is a way to index on > expressions, but even this can be worked around with triggers (at some > cost). > > 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
