JSONiq: The JSON Query Language

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

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.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • jfq

    JSONata on the command line

  • if anyone's here looking for javascript-language json query-er, I've been using jsonata. found it deep and well-thought out, and not too hard to get my head around the syntax

    https://jsonata.org

  • 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.

    InfluxDB logo
  • brackit

    Query processor with proven optimizations, ready to use for your JSON store to query semi-structured data with JSONiq. Can also be used as an ad-hoc in-memory query processor.

  • We're working on an implementation for SirixDB with currently a slightly different syntax (for instance "=>" to dereference object fields). We're also supporting all kinds of temporal query enhancements (point in time queries, time travel queries...):

    https://github.com/sirixdb/sirix

    The query engine used is developed here (core implemented by Sebastian Bächle and his tudents). Ideally the backend can be any other data store as well.

    https://github.com/sirixdb/brackit

  • gron

    Make JSON greppable!

  • Good points. JSON processing tools I find helpful in addition to JavaScript include Gron aka "grep for JavaScript" ( https://github.com/tomnomnom/gron ), jq for querying, json_pp for pretty-printing and `bat` for syntax highlighting.

  • jmespath.py

    JMESPath is a query language for JSON.

  • GROQ

    Specification for GROQ - The Query Language for JSON

  • sirix

    SirixDB is an an embeddable, bitemporal, append-only database system and event store, storing immutable lightweight snapshots. It keeps the full history of each resource. Every commit stores a space-efficient snapshot through structural sharing. It is log-structured and never overwrites data. SirixDB uses a novel page-level versioning approach.

  • We're working on an implementation for SirixDB with currently a slightly different syntax (for instance "=>" to dereference object fields). We're also supporting all kinds of temporal query enhancements (point in time queries, time travel queries...):

    https://github.com/sirixdb/sirix

    The query engine used is developed here (core implemented by Sebastian Bächle and his tudents). Ideally the backend can be any other data store as well.

    https://github.com/sirixdb/brackit

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

  • Whats Wrong with Java/Spring

    1 project | /r/java | 28 Mar 2023
  • Brackit - a flexible query compiler for JSON, separating key concerns in query processing

    1 project | /r/Database | 14 Mar 2022
  • Flexible JSON Query Compiler – Separating Key Concerns in Query Processing

    1 project | news.ycombinator.com | 14 Mar 2022
  • Show HN: Brackit – Separating Key Concerns in JSON Query Processing

    1 project | news.ycombinator.com | 3 Mar 2022
  • Brackit – An alternative to JQ and JMESPath to query JSON

    1 project | news.ycombinator.com | 3 Mar 2022