On Tue, Oct 21, 2014 at 4:01 PM, Mike Jarmy mja...@gmail.com 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
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
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:
On Tue, Oct 21, 2014 at 10:14 AM, Dominique Devienne ddevie...@gmail.com
wrote:
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
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,
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
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
On Tue, Oct 21, 2014 at 10:14 AM, Dominique Devienne
ddevie...@gmail.com wrote:
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
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 2:13 PM, Mike Jarmy mja...@gmail.com 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. Sqlite's
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
11 matches
Mail list logo