We’ll probably look at providing a set of functions for handling JSON in SQLite, similarly to what POSTGRESQL is doing. But, to make it efficient, we need to index the JSON content. I suggested earlier this year to get expression based indexes, so one can index the result of a function like json_path(“my column”,”a.b.c”) to speed up the search.
That would be my own, single item, wish list :-) It can definitively open many doors. Happy new year, and I wish you guys a great 2015 year! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users