querycsv
sq
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.
querycsv
sq
-
Show HN: I built jq-like scriptable tool to query CSV and JSON with SQLite
Is this related to the other SQ? https://github.com/neilotoole/sq
-
Best way to introduce a linter?
For my main OSS project, sq, its .golangci.yml is a lightly customized version of this gist from maratori. I found it to be a good starting point.
-
Go port of SQLite without CGo
Thankfully I no longer need to maintain xcgo, but even today, the sq pipeline is still complex with lots of platform-dependent bits.
-
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.
- sq: swiss-army knife for data
-
sq: swiss-army knife to inspect, query, join, import, and export data
Available on Git? Absolutely. https://github.com/neilotoole/sq
What are some alternatives?
csvq - SQL-like query language for csv
unioffice - Pure go library for creating and processing Office Word (.docx), Excel (.xlsx) and Powerpoint (.pptx) documents
trdsql - CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
omniparser - omniparser: a native Golang ETL streaming parser and transform library for CSV, JSON, XML, EDI, text, etc.
dsq - Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.
csvdecoder - Go library for parsing and deserialising CSV files into Go objects
octosql - OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
csv-sql - Command-line tool to load csv and excel (xlsx) files and run sql commands
ytwrk - YT metadata exporter
ExternData - :page_facing_up: Modelica library for data I/O of CSV, INI, JSON, MATLAB MAT, SSV, TIR, Excel XLS/XLSX and XML files
excelize - Golang library for reading and writing Microsoft Excel™ (XLSX) files.