Command line tools
- GitHub - dinedal/textql: Execute SQL against structured text like CSV or TSV
- GitHub - BurntSushi/xsv: A fast CSV command line toolkit written in Rust.
- csvkit 1.0.3 — csvkit 1.0.3 documentation
- Miller – “Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON. You get to work with your data using named fields, without needing to count positional column indices.”
- interesting thread
- tab – A modern text/number processing language for the shell.
- Table Tool is a fast, open source, mac native application to open csv files. I have set this as my default CSV opener.
Apache Metamodel provides a common interface for discovery, exploration of metadata and querying of different types of data sources. Uniform connector and query API for CSV & data formats, relational databases, noSQL databases.
With MetaModel you use a type-safe SQL-like API for querying any datastore:
= DataContextFactory.create[TypeOfDatastore](...); DataContext dataContext = dataContext.query() DataSet dataSet .from("libraries") .select("name") .where("language").eq("Java") .and("enhances_data_access").eq(true) .execute();
The MetaModel query API allows you to use the power of SQL, even on data formats such as CSV files, Excel spreadsheets, NoSQL databases and more.