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
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
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.
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
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?
>>
>>
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
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
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,
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?
> >
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:
>
>
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
11 matches
Mail list logo