Re:DuckDB as the New jq
by edu_guitar on Thursday March 21, 2024 @08:48PM
(#39786260)
if you are used to the command line and knows some basic syntax, it is less verbose then opening a REPL and reading a file. The fact that you can pipe the json data into it is also a plus, making it easier to check quickly if the response of a curl call has the fields/values you were expecting. Of course, if you are more comfortable doing that from the REPL, you get less value from learning jq. If you are fond of one liners, jq offers a lot of potential.
Pipelining CLI commands or bash scripts. From a security perspective, it may be preferable to not ship with a runtime.
bash and jq are both runtimes.
Very difficult (or often impractical) to not have a shell at all, and jq is at least limited in scope, and has no dependencies that need to be installed. Far better than a full language with its own standard library and set of dependencies to lock down.
Use a compiled language like golang if you don't want to ship with a runtime.
If you're willing to ship w/ bash then I don't understand the opposition to JS. Either tool puts you in a scenario where somebody who can exec into your env can do whatever they want
Re:DuckDB as the New jq
by WuxiFingerHold on Friday March 22, 2024 @05:31AM
(#39788859)
My thoughts as well:
const response = await fetch("https://api.github.com/orgs/golang/repos");
const repos = await response.json();
const groups = Map.groupBy(repos, e => e?.license?.key);
...
If you want to work with it interactively, you could use a notebook or REPL.