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.

There was UnQL a few years back, but this was abandoned. --DD

http://www.infoq.com/news/2011/08/UnQL
http://unql.sqlite.org/index.html/wiki?name=UnQL
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to