gojq
textql
Our great sponsors
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
gojq
-
To a Man with `Jq`, Everything Looks Like JSON
Yeap i've talked to itchyny quite a lot about various changes https://github.com/itchyny/gojq/issues/153 and also upstreamed quite a lot https://github.com/itchyny/gojq/issues?q=author%3Awader like custom iterators (to allow eval, own iterators and "empty" functions), query marshalling (query rewrite tricks) and a bunch of small things and bug fixes. But the largest change to add a JQValue interface is quite complex, other changes like extended literals is also a bit tricky.
Hmm weird list of changes for https://github.com/wader/gojq/compare/fq...itchyny:gojq:main but i guess it is because i haven't kept my main branch in sync. The fq branch should be based on latest gojq/main as of now. I usually try to rebase as quick as possible.
Let me know if you have any other questions or want to help out! maybe email etc as i usually don't check HN comments replies that often :)
- Make JSON Greppable
- Jaq – A jq clone focused on correctness, speed, and simplicity
-
jq 1.7 Released
gojq has support for yaml input (via a very annoying argument name) and also has the golang property of "curl binary; chmod; profit": https://github.com/itchyny/gojq#difference-to-jq
It's error reporting is also clang-vs-gcc level wizardry, and I often use it to get a helpful message instead of "ENOWORKY" from jq (I haven't tried 1.7 yet, so it could be better for all I know)
-
First release of jq in 5 years
Some competition for https://github.com/itchyny/gojq. I had read somewhere that it was faster than jq - no idea if that's still the case.
-
Library to analyze an arbitrary JSON string
JQ has a go implementation usable as a library I see. The project looks fairly active https://github.com/itchyny/gojq
-
Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, and tabular JSON
I've been getting a lot of mileage out of https://github.com/itchyny/gojq#readme recently due to two things: its vastly superior error messages and the (regrettably verbose) `--yaml-input` option
I also have https://github.com/01mf02/jaq#readme installed but just haven't needed it
-
Yq is a portable yq: command-line YAML, JSON, XML, CSV and properties processor
I use gojq with --yaml-input or --yaml-output and flip back and forth between JSON and YAML promiscuously and have 100% jq UI compat, which helps because I use jq a lot. First thing I looked at on yq is '-s', which is 'slurp' for jq. Slightly altered semantics would just trip me up, and it seems like you can make a nearly straight bijection between YAML and jq so you can just do exactly the same things with either one (with some minor exceptions.)
https://github.com/itchyny/gojq
-
Looking for programming languages created with Go
jq https://github.com/itchyny/gojq
-
Oracle DB support in Benthos
github.com/itchyny/gojq -> similar to goawk, except JQ this time
textql
-
Jaq – A jq clone focused on correctness, speed, and simplicity
I like textql [0] better for this use case, as it's simpler in my mind.
[0] https://github.com/dinedal/textql
-
Can SQL be used without an RDBMS?
Primarily, you are right. SQL is for working with structured data and that largely covers RDBs. However, there are tools (like textql) that allow you to query CSV files and the effort works with most other text files that have some kind of structure.
- Textql: Execute SQL against structured text like CSV or TSV
-
Show HN: ClickHouse-local – a small tool for serverless data analytics
As the author of textql ( https://github.com/dinedal/textql ) - thanks for the shoutout!
Looks great, I love more options in the space for CLI based data analysis tools! Fantastic work!
- Using Commandline To Process CSV files
-
sqly - execute SQL against CSV / JSON with shell
Apparently, there were many who thought the same thing; Tools to execute SQL against CSV were trdsql, q, csvq, TextQL. They were highly functional, hoewver, had many options and no input completion. I found it just a little difficult to use.
-
Q – Run SQL Directly on CSV or TSV Files
Reminds me of the textQL extension that's available in Asciidoc.
Point it to an external CSV file, enable TextQL, and bam, there's your query returned as a table. Handy for parts lists, inventory, that kind of crap.
https://github.com/dinedal/textql
https://gist.github.com/mojavelinux/8856117
-
Beginner interested in learning SQL. Have a few question that I wasn’t able to find on google.
Through more magic, you COULD of course use stuff like Spark, or easier with programs like TextQL, sq, OctoSQL.
-
textql VS trdsql - a user suggested alternative
2 projects | 25 Jun 2022
-
Xlite: Query Excel, Open Document spreadsheets (.ods) as SQLite virtual tables
Somewhat-kinda related, the textql extension for Asciidoctor is so dang useful it should be in core.
https://gist.github.com/mojavelinux/8856117
I use this as a "centralized parts repository" for big ol' maintenance manuals. Refresh from PDM/PLM/LSA/Whatever. Rebuild for new parts data.
Built on TextQL, natch
https://github.com/dinedal/textql
What are some alternatives?
jq - Command-line JSON processor [Moved to: https://github.com/jqlang/jq]
q - q - Run SQL directly on delimited files and multi-file sqlite databases
jq - Command-line JSON processor
go-duckdb - go-duckdb provides a database/sql driver for the DuckDB database engine.
yq - yq is a portable command-line YAML, JSON, XML, CSV, TOML and properties processor
octosql - OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
counsel-jq - Traverse complex JSON and YAML structures with live feedback
cq - Query CSVs using SQL
jfq - JSONata on the command line
dsq - Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
zed - A novel data lake based on super-structured data
brackit - Query processor with proven optimizations, ready to use for your JSON store to query semi-structured data with JSONiq. Can also be used as an ad-hoc in-memory query processor.