DuckDB as the New jqmatcha_addict@lemy.lol to Linux@lemmy.ml – 50 points – 6 months agopgrs.net5Post a CommentPreviewHotTopNewOldCool, 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.
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.
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.
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.