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.
this post was submitted on 22 Mar 2024
51 points (98.1% liked)
Linux
48061 readers
1106 users here now
From Wikipedia, the free encyclopedia
Linux is a family of open source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991 by Linus Torvalds. Linux is typically packaged in a Linux distribution (or distro for short).
Distributions include the Linux kernel and supporting system software and libraries, many of which are provided by the GNU Project. Many Linux distributions use the word "Linux" in their name, but the Free Software Foundation uses the name GNU/Linux to emphasize the importance of GNU software, causing some controversy.
Rules
- Posts must be relevant to operating systems running the Linux kernel. GNU/Linux or otherwise.
- No misinformation
- No NSFW content
- No hate speech, bigotry, etc
Related Communities
Community icon by Alpár-Etele Méder, licensed under CC BY 3.0
founded 5 years ago
MODERATORS
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.