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