JSON Query

39•wofo•2h ago

Comments

jawns•1h ago

I'd like to know how it compares to https://jsonata.org

Alifatisk•1h ago

Can't you just visit both pages, build an understanding and compare them?

OrderlyTiamat•1h ago

Maybe the author would be in a better place to do that, having the expertise already. Also, as a user I'm quite happy with jq already, so why expend the effort?

gfody•1h ago

not to be confused with jq for querying json?

tcdent•1h ago

Doesn't the command-line utility `jq` already define a protocol for this? How do the syntaxes compare?

(LLMs are already very adept at using `jq` so I would think it was preferable to be able to prompt a system that implements querying inside of source code as "this command uses the same format as `jq`")

jonny_eh•31m ago

For convenience: https://en.wikipedia.org/wiki/Jq_(programming_language)

npodbielski•1h ago

Nice. I work on something similar but for .net.

gabrielsroka•31m ago

They have an implementation for .net https://jsonquerylang.org/implementations/#net

memelang•51m ago

I've been working on an ultra-token-efficient LLM-friendly query language. https://memelang.net/09/

wofo•48m ago

I'm working on a tool that will probably involve querying JSON documents and I'm asking myself how to expose that functionality to my users. I like the power of `jq` and the fact that LLMs are proficient at it, but I find it right out impossible to come up with the right `jq` incantations myself. Has anyone here been in a similar situation? Which tool / language did you end up exposing to your users?

arccy•43m ago

In the k8s world there's a random collection of json path, json query, some random expression language.

Just use jq. None of the other ones are as flexible or widespread and you just end up with frustrated users.

pscanf•20m ago

I have a similar use case in the app I'm working on. Initially I went with JSONata, which worked, but resulted in queries that indeed felt more like incantations and were difficult even for me to understand (let alone my users).

I then switched to JavaScript / TypeScript, which I found much better overall: it's understandable to basically every developer, and LLMs are very good at it. So now in my app I have a button wherever a TypeScript snippet is required that asks the LLM for its implementation, and even "weak" models one-shot it correctly 99% of the times.

It's definitely more difficult to set up, though, as it requires a sandbox where you can run the code without fears. In my app I use QuickJS, which works very well for my use case, but might not be performant enough in other contexts.

HatchedLake721•3m ago

https://jsonpath.com/ or https://jsonata.org/

wofo•1m ago

Would you mind sharing a bit more? Have you used them? How did that go?

linhns•45m ago

Nice work with a jq-esque feel. Website is cut on mobile devices though

lenkite•43m ago

There are a ridiculous number of JSON query/path languages. Wish all the authors got together and harmonized on a standard.

nartho•37m ago

Plus, I feel like most, if not all, higher level languages already come with everything you need to do that easily. Well except for go that requires you to create your own filter function.

miohtama•37m ago

Xkcd.gif

thayne•26m ago

There is a standard in RFC 9535 (JSONPath)[1]. But as far as I can tell, it isn't very widely used, and it has more limited functionality than some of the alternatives.

[1]: https://datatracker.ietf.org/doc/html/rfc9535

NewJazz•17m ago

Postgresql supports jsonpath, right?

Groxx•5m ago

SQLite might too, though I'm struggling to find anything explicit about the syntax: https://sqlite.org/json1.html#jptr

it might just be a very limited subset?

Re: A Few Comments on 'Age' (2019)

'Where the hell is the market risk?' Scott Bessent takes on his critics

Assort Health Engineering Open House

Traveling Flame Discovery [video]

How to organize your Rust tests

What I want from the UK National Data Library (it's vibe coding)

Windows will soon prompt for memory scans after BSOD crashes

Design and reconstructible history of the Mayan eclipse table of Dresden Codex

FRDM Inc – Hiring "Full Stack Engineer (AI+LLM Focus)"

DeepSeek OCR with Vllm – 10x cheaper on cloud GPU

We Might Not Be So Strange

Cancer has a surprising amount of detail

Odyssey-2: instant, interactive AI video

Australia Invented WiFi (2012)

Canonical releases silicon-optimized inference snaps

ShaderPad – Real-Time GLSL Shader Playground

IP address truncation is not anonymization

Learning from Abundant User Dissatisfaction in Real-World Preference Learning

Spacing the Circles on the Smith Chart

Tinier Than a Grain of Sand: Physicists Create the Smallest Light Pixel

Google President: 'We should be able to cure cancer in our lifetime' with AI

UN expert Reem Alsalem: surrogacy is a system of violence, exploitation & abuse

Global Shift: Electrification Captures All Energy Demand Growth [video]

'AI' Sucks the Joy Out of Programming

ChatGPT Users Show Signs of Psychotic Crisis Every Week

When Models Manipulate Manifolds: The Geometry of a Counting Task

Language Models Are Injective and Hence Invertible

Graphing the Ransomware Payment Ecosystem Using STIX Objects

"A medical miracle": is period blood an overlooked opportunity in womens health?

The AI Wildfire Is Coming. It's Going to Be Painful and Healthy