Good candidate for querying large tree-like data ?

[Thad Guidry]

https://rumble.readthedocs.io/en/latest/

I've setup a local native Spark install on my Windows server and been playing with RumbleDB against the Wikidata JSON dump.  It's been fun and "interesting".

For us in OpenRefine, we potentially could use it for SQL like JSON query and transformation and might fit parts of it in.  I really like the SQL like syntax and JSONiq FLWOR expressions are right in line with SPARQL's XQuery capability and FLWOR support.

I also pinged Peter Ohler who maintains OjC and OjG and said this in a recent reply to me:

While OjC is fast it does not have support for doing anything with the data once parsed. If you are looking for a fast parser and support for JSONPath you might consider looking at my OjG project (https://github.com/ohler55/ojg). While not as fast as OjC it has a fairly complete JSONPath implementation. I’m also happy to add any missing features. Of course that means using golang so maybe that doesn’t fit in with your plans.

Thad

https://www.linkedin.com/in/thadguidry/

https://calendly.com/thadguidry/