Hmm, UnQL looks like just what I was looking for. Seems like the project never really got rolling though.
DocumentDB looks very interesting. There is a lot of activity in this space I think -- the Postgres 'jsonb' stuff is really great. An embedded solution is what I need though :-) On Tue, Oct 21, 2014 at 11:35 AM, Cory Nelson <phro...@gmail.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: > > > > > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
