csv-sql
sq
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.
csv-sql
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?
octosql - OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
unioffice - Pure go library for creating and processing Office Word (.docx), Excel (.xlsx) and Powerpoint (.pptx) documents
goose - A database migration tool. Supports SQL migrations and Go functions.
omniparser - omniparser: a native Golang ETL streaming parser and transform library for CSV, JSON, XML, EDI, text, etc.
mergestat-lite - Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊
csvdecoder - Go library for parsing and deserialising CSV files into Go objects
excelize - Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
upper.io/db - Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
querycsv - QueryCSV enables you to load CSV files and manipulate them using SQL queries then after you finish you can export the new values to a CSV file
mergestat - MergeStat enables anyone to ask questions about the history and contents of source code.
ytwrk - YT metadata exporter