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: > > > > http://www.postgresql.org/docs/9.4/static/datatype-json.html > > > > It would be extremely useful for me if a similar facility were available > in > > sqlite. I can sort of fake some of what I need via FTS, but true JSON > > support would be wonderful. > > > > Would be nice, true. But then you need some kind of XPath or XQuery for > JSON on the query side. > Microsoft's DocumentDB modifies SQL to work pretty well with unstructured JSON. This might provide some inspiration. http://azure.microsoft.com/en-us/documentation/articles/documentdb-sql-query/ -- Cory Nelson http://int64.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users