News for hackers. Stuff that matters.
Re:Show HN: JSON Query by peterohler on Monday October 27, 2025 @02:59PM (#45724931)
If you prefer JSONPath as a query language, oj from https://github.com/ohler55/ojg provides that functionality. It can also be installed with brew. (disclaimer, I'm the author of OjG)
Re:Show HN: JSON Query by tyre on Monday October 27, 2025 @03:13PM (#45725101)
JSONPath is also supported by Postgres!

Helpful when querying JSON API responses that are parsed and persisted for normal, relational uses. Sometimes you want to query data that you weren’t initially parsing or that matches a fix to reprocess.

Re:Show HN: JSON Query by Eric_WVGG on Monday October 27, 2025 @03:36PM (#45725344)
speaking of classic databases: can anyone explain to me, a dummy, why any syntax like this or even GraphQL is preferable to "select a.name, a.age from friends a where a.city = 'New York' order by a.age asc"?