Show HN: Jsont – CLI to explore and query JSON/JSONL files, built for AI agents

2 pointsposted 5 hours ago
by okaris

2 Comments

WorldMoodMaker

5 hours ago

This looks solid for quick exploration. How does jsont handle very large JSONL files (e.g., several GBs) compared to something like jq? I often have to parse massive streams of real-time event data, and speed is the main bottleneck for my agents.

okaris

5 hours ago

It streams line by line so constant memory for filter/select/first/find operations. It won't load a 5GB file into RAM.

That said, operations that need to see everything (sort, group by, stats) do buffer in memory. For those on massive files, `first N` or `where` before the sort helps.

Honest answer: I haven't benchmarked against jq (and wouldn't call it a replacement) on multi-GB files yet. jq is C, jsont is Go. For pure filtering speed jq probably wins. The value is in the explore commands (schema, find, stats) that jq simply doesn't have. and the way agents can interact with this cli which should save you/them 10 minutes of guessing on a file you've never seen.