mlinux·Linuxbymatcha_addict DuckDB as the New jqhttps://www.pgrs.net/2024/03/21/duckdb-as-the-new-jq/Open linkView original on lemy.lol48Comments5
D_Air1 lemmy.ml1Hide 1 replyCool, so jq but using sql instead of custom syntax. I wonder if it can output to plain text. That is what I usually use jq for.7
jjh0wlett replydiscuss.tchncs.dejq is mot custom syntax though, it is just JSONPath standarsld. Which is also used to query JSON in JSON fields in MySQL for instance.3
aatzanteol sh.itjust.worksThat's neat! Reminds me of steampipe which provides a sql interface to apis. You can also use it for csv, json and yaml. Nice thing about steampipe is that it can look like a postres db to any sql client.4
tetris11 lemmy.mlDuckDB have been promoting hard these last few weeks. I saw them on HN a few days ago, and now here.3
Cool, so jq but using sql instead of custom syntax. I wonder if it can output to plain text. That is what I usually use jq for.
jq is mot custom syntax though, it is just JSONPath standarsld. Which is also used to query JSON in JSON fields in MySQL for instance.
That's neat! Reminds me of steampipe which provides a sql interface to apis. You can also use it for csv, json and yaml.
Nice thing about steampipe is that it can look like a postres db to any sql client.
I finally build something nontrivial in jq, then this happens...
DuckDB have been promoting hard these last few weeks. I saw them on HN a few days ago, and now here.