Re: [sqlite] JSON indexing

2014-10-21 Thread Mike Jarmy
s idea: https://www.mail-archive.com/sqlite-users@sqlite.org/msg85934.html something like that seems like its probably a necessary first step to being able to build a JSON index on disk. On Tue, Oct 21, 2014 at 4:29 PM, Nico Williams wrote: > On Tue, Oct 21, 2014 at 2:13 PM, Mike Jarmy wrote:

Re: [sqlite] JSON indexing

2014-10-21 Thread Mike Jarmy
similar to how Postgres does it. On Tue, Oct 21, 2014 at 2:47 PM, Nico Williams wrote: > On Tue, Oct 21, 2014 at 10:14 AM, Dominique Devienne > wrote: > > On Tue, Oct 21, 2014 at 3:38 PM, Mike Jarmy wrote: > > > >> Has there been any discussion of adding JSON indexing

Re: [sqlite] JSON indexing

2014-10-21 Thread Mike Jarmy
-) On Tue, Oct 21, 2014 at 11:35 AM, Cory Nelson wrote: > On Tue, Oct 21, 2014 at 10:14 AM, Dominique Devienne > wrote: > > > On Tue, Oct 21, 2014 at 3:38 PM, Mike Jarmy wrote: > > > > > Has there been any discussion of adding JSON indexing to sqlite, > similar

[sqlite] JSON indexing

2014-10-21 Thread Mike Jarmy
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