Re: SQL for JSON?
- TrimQuery solution is right pretty, but.... not for tree-based
Visitor pattern and XPATH on XML realy designed for tree.
written by Steffen Meschkat <mesch@...>. It's realy titanic
solution, but it's designed for XML.
function visit(aTree, anAcceptor, aVisitProcessor)
I proceed from the assumption:
- 90% tasks are based on search by equals or like.
- 10% tasks can be realized by custom "acceptor" and/or custom "visit
Moreover, Visitor allowed to modify tree so well as search from them.
For example, I can design code, that removed from JSON data structure
all persons whose birth day arrived on full Moon (20 lines of code).
Java Visitor on Tree vs. Events named Digester
Of course Visitor is not competed with SQL (especially on server with
indexes, cache etc), Visitor is not a rival for XPATH on XML.
TrimQuery solution is very good and very helpful, but for JSON
JsonTools is preffered more...
Regards, Alexey Luchkovsky
--- In firstname.lastname@example.org, "Anand Sadasivam" <anand.sadasivam@...>
> Check out this...
> you can see the demo right here...
> http://trimpath.com/demos/test1/trimpath/query_demo.html .
> Hope this helps.
> On 2/26/07, Alexey Luchkovsky <luchkovsky@...> wrote:
> > --- In email@example.com <json%40yahoogroups.com>,
> > george.jempty@> wrote:Morley"
> > >
> > > --- In firstname.lastname@example.org <json%40yahoogroups.com>, "Matthew
> > <WickedLogic@> wrote:is a web
> > > > If you are working in an environment where the JSON consumer
> > > > browser, let the server do the heavy lifting and pass you thenon-browser
> > > matches. If
> > > > you really need the local ability to search or are doing
> > > > exchanges, I am sure there exists generic functions to searchanyone
> > > through sets
> > > > of data and match criteria. The real question is which language
> > you are
> > > > doing it in, and is it worth the overhead and complication.
> > >
> > > Baloney. The real question is the OP's original question: "Has
> > > played with a way to find parts of a JSON structure like SQL?" Thise-mail me.
> > > is not an unreasonable question: in fact its been considered by
> > > renowned Python/XML expert Uche Ogbuji; see
> > > http://copia.ogbuji.net/blog/2006-12-23/Why_JSON_v
> > > where he imagines "XQuery for JSON". By the way, a link to this very
> > > same article can be found at the bottom of json.org.
> > >
> > JsonTools included solution for client lookup JSON data, you can find
> > parts of a JSON structure, if you need concrete decision, send
> +91 99804 75305
> [Non-text portions of this message have been removed]