FX: An interactive alternative to jq to process JSON

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • jid

    json incremental digger

    Apparently, the author wrote this tool because jid was struggling with a 7MB JSON file.

    See https://github.com/simeji/jid/issues/66#issuecomment-4436718...

  • fx

    Terminal JSON viewer & processor

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • jp

    Command line interface to JMESPath - http://jmespath.org

    There’s also jp, which interprets JMESPath: https://github.com/jmespath/jp

    This one has the advantage of being natively understood by aws-cli, meaning you can pass a JMESPath to an AWS call and only receive the filtered / transformed result back.

  • rq

    Record Query - A tool for doing record analysis and transformation (by dflemstr)

  • gofx

    Discontinued 🐾 fx-like command-line JSON processing tool

  • pq

    Like jq, but with Python (by dvolk)

    If you want to use jq but with Python syntax, I wrote pq:

    https://github.com/dvolk/pq

  • gron

    Make JSON greppable!

    gron [0] is another interesting JSON processor that follows UNIX philosophy:

    [0] https://github.com/tomnomnom/gron

    "Make JSON greppable!"

    "gron transforms JSON into discrete assignments to make it easier to grep for what you want and see the absolute 'path' to it."

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • datastation

    App to easily query, script, and visualize data from every database, file, and API.

    If you're into the SQL side (compared to jq's custom query language) of querying arbitrary files I've got a comparison of some major tools here too.

    https://github.com/multiprocessio/datastation/tree/main/runn....

  • ojg

    Optimized JSON for Go

    Another alternative is the oj app (ojg/cmd/oj) which is part of https://github.com/ohler55/ojg. It relies on JSONPath for extraction and manipulation of JSON.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts