mlinux·Linuxbymatcha_addict DuckDB as the New jqhttps://www.pgrs.net/2024/03/21/duckdb-as-the-new-jq/Open linkView original on lemy.lol48Comments5Reply
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.7Reply
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.3Reply
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.4Reply
tetris11 lemmy.mlDuckDB have been promoting hard these last few weeks. I saw them on HN a few days ago, and now here.3Reply
5 replies
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.