Re: [sqlite] JSON indexing

2014-10-22 Thread Nico Williams
On Tue, Oct 21, 2014 at 4:01 PM, Mike Jarmy wrote: > something like that seems like its probably a necessary first step to being > able to build a JSON index on disk. To be fair, there are other ways it could be done. But I would prefer a mechanism that allows for external

Re: [sqlite] JSON indexing

2014-10-21 Thread Mike Jarmy
jq looks very interesting. I have a simplistic filtering syntax to work with right now, as part of a third-party API definition that my system needs to support, but it doesn't support querying into nested structures. jq looks like just the ticket for that. I'm sure I'll take a look when the

Re: [sqlite] JSON indexing

2014-10-21 Thread Nico Williams
On Tue, Oct 21, 2014 at 2:13 PM, Mike Jarmy wrote: > I could probably use an Entity-Attribute-Value approach to modeling JSON Yes. > I can sort of work around needing to query embedded data structures like > lists and json objects, so EAV would more or less work for me.

Re: [sqlite] JSON indexing

2014-10-21 Thread Mike Jarmy
It appears that neither Unqlite nor sculejs supported disk-based indexing of arbitrary JSON data, which is the use case I'm looking at here (they both look cool though). I already have something very similar to sculejs, but I currently keep all the JSON documents in RAM, which is not going to

Re: [sqlite] JSON indexing

2014-10-21 Thread Nico Williams
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 to >> the way Full Text Search and R-Tree are available? >> >>

Re: [sqlite] JSON indexing

2014-10-21 Thread Neville Dastur
Originally built for Appcelerator but now covers more than that https://github.com/dan-eyles/sculejs this library might be what you are looking for. Neville — Surgeons Net Education: http://www.surgeons.org.uk Clinical Software Solutions: http://www.clinsoftsolutions.com Find our free and paid

Re: [sqlite] JSON indexing

2014-10-21 Thread Peter Aronson
I've never used it myself, but there is http://www.unqlite.org/, which is an embedded document store database library. I believe it uses JSON as native storage format, and it supports an embedded scripting language to access the contents. The Unqlite forums seem active, so it seems to be

Re: [sqlite] JSON indexing

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

Re: [sqlite] JSON indexing

2014-10-21 Thread Cory Nelson
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 > to > > the way Full Text Search and R-Tree are available? > >

Re: [sqlite] JSON indexing

2014-10-21 Thread Dominique Devienne
On Tue, Oct 21, 2014 at 3:38 PM, Mike Jarmy 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: > >

[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