Skip Navigation

Scout Archives

Home Projects Publications Archives About Sign Up or Log In

csvq

For a tool offering a SQL-like query and update language for CSV, TSV, LTSV, JSON, and fixed-width data files, readers should check out csvq. Users can extract subsets of the data using the familiar SELECT ... WHERE syntax; generate summaries with aggregate functions such as COUNT, AVG, MEDIAN, and others; or transform the structure of a data file with ALTER TABLE statements. Multiple operations can be handled as a group using csvq's interactive shell. Within these groups of operations, users can also make use of several familiar features from database systems, including variables, cursors, and temporary tables. The "Command Usage" section of the Reference Manual (in the menu on the left side of the page) describes the various ways that csvq can be invoked and gives examples of each. The remainder of the manual provides a detailed technical reference to the query language. The "Download" link on the page linked above provides binaries for Windows, macOS, Linux, and BSD systems.
Archived Scout Publication URL
Scout Publication
Publisher
GEM Subject
Language
Date of Scout Publication
October 1st, 2021
Date Of Record Creation
August 23rd, 2021 at 4:32pm
Date Of Record Release
September 21st, 2021 at 11:39am
Resource URL Clicks
57
Add Comment

Comments

(no comments available yet)