Welcome to rjq 👋

Simple and fast JSON filtering tool written in Rust.

🏠 Homepage

Usage

rjq --load="<file path>" --query="<query string>" --params="<comma separated parameter names>"

or,

stto --json cpython | rjq --query="<query string>" --params="<comma separated parameter names>"

Demo data.json:

[
  {
    "_id": "88L33FM4VQBB1QYH",
    "name": "Eleonore Kendall",
    "dob": "2021-04-13",
    "address": {
      "street": "3137 Stich Avenue",
      "town": "Swanley",
      "postode": "CR45 9NE"
    },
    "telephone": "+49-2424-456-409",
    "pets": [
      "Murphy",
      "Oliver"
    ],
    "score": 2.4,
    "email": "etheleneweston@shuttle.com",
    "url": "http://www.consultant.com",
    "description": "mobiles besides deputy australian picnic germany collectables gmc necessity both webcams testing set continuity bread candle drivers p icon alone",
    "verified": true,
    "salary": 24057
  },
  {
    "_id": "OQGS24A7RF6D118C",
    "name": "Shona Breen",
    "dob": "2017-08-13",
    "address": {
      "street": "6515 Camberley",
      "town": "Fortrose",
      "postode": "SS64 6WU"
    },
    "telephone": "+42-1296-691-224",
    "pets": [
      "Lilly",
      "Penny"
    ],
    "score": 8,
    "email": "gerald-love@para.rome.it",
    "url": "http://district.com",
    "description": "collective submitted samuel del kenya fi wordpress etc worked realize enzyme ethernet assured championships preferred examples virtual bluetooth urw trust",
    "verified": false,
    "salary": 10760
  },
  {
    "_id": "YI818QFFYNA6AZUH",
    "name": "Dot Milton",
    "dob": "2015-03-01",
    "address": {
      "street": "2151 Kenstford",
      "town": "Coldstream",
      "postode": "WN26 1ZO"
    },
    "telephone": "+45-8699-662-747",
    "pets": [
      "Murphy",
      "Bear"
    ],
    "score": 2.4,
    "email": "karla.harrington4058@relation.com",
    "url": "https://www.minolta.com",
    "description": "segments programmes tulsa acre placing prix awarded senators main trim played italiano difficulties cab customers granny document pf exceptions attractions",
    "verified": true,
    "salary": 54912
  },
  ...
]

rjq query:

rjq --load="data.json" --query="salary < 15000 && score < 2.0 && verified = false" --params="name, address.town, pets"

output:

[
  {
    "name": "Rosaura Thurston",
    "pets": [
      "BatMan",
      "Leo"
    ],
    "town": "Matlock"
  },
  {
    "name": "Bernardina Bateman",
    "pets": [
      "sox",
      "Stella"
    ],
    "town": "Petersfield"
  },
  {
    "name": "Miquel Cranford",
    "pets": [
      "Oscar",
      "Oliver"
    ],
    "town": "Olney"
  },
  {
    "name": "Hanna Scherer",
    "pets": [
      "Sammy",
      "Penny"
    ],
    "town": "Greenhill"
  },
  {
    "name": "Arcelia Woodcock",
    "pets": [
      "boo",
      "Lexi"
    ],
    "town": "Kendal"
  },
  {
    "name": "Kayce Gable",
    "pets": [
      "Leo",
      "Murphy"
    ],
    "town": "Otley"
  },
  ...
]

Benchmark

❯ hyperfine -N --warmup 10 'rjq --load="test.json" --query="salary < 15000 && score < 2.0 && verified = false"' "jq '.[] | select(.salary<15000 and .score<2.0 and .verified==false)' test.json"
Benchmark 1: rjq --load="test.json" --query="salary < 15000 && score < 2.0 && verified = false"
  Time (mean ± σ):     163.0 ms ±   0.9 ms    [User: 125.6 ms, System: 37.1 ms]
  Range (min … max):   161.9 ms … 164.8 ms    18 runs

Benchmark 2: jq '.[] | select(.salary<15000 and .score<2.0 and .verified==false)' test.json
  Time (mean ± σ):     332.3 ms ±   2.1 ms    [User: 306.4 ms, System: 25.6 ms]
  Range (min … max):   328.9 ms … 335.8 ms    10 runs

Summary
  'rjq --load="test.json" --query="salary < 15000 && score < 2.0 && verified = false"' ran
    2.04 ± 0.02 times faster than 'jq '.[] | select(.salary<15000 and .score<2.0 and .verified==false)' test.json'

Author

👤 Mainak Bhattacharjee

• Github: @mainak55512

🤝 Contributing

Contributions, issues and feature requests are welcome!
Feel free to check issues page.

Show your support

Give a ⭐️ if this project helped you!