trdsql
Posted on:
This is the document of trdsql, a tool that can execute SQL on CSV, LTSV, JSON, YAML, TBLN files.
overview
trdsql is a CLI tool that executes SQL on text in table format. A tabular format is data that consists of rows and columns, such as:
| 1 column | 2 columns | |
|---|---|---|
| 1 row | a1 | a2 |
| 2 row | b1 | b2 |
Since the results can be output in various formats, it can also be used for format conversion of tabular data.
table of contents
- trdsql install
- trdsql File format conversion
- trdsql Easy SQL
- trdsql simple SQL 2
- trdsql Aggregation
- trdsql aggregation calculation
- trdsql GROUP aggregation
- trdsql Log aggregation
- trdsql wildcard, compressed file
- trdsql stdin
- trdsql internal processing overview
- trdsql PostgreSQL Engine
- trdsql MySQL Engine
- trdsql SQLite3 Engine
- trdsql DB import
- trdsql JOIN
- Joining Files and Tables with trdsql
- Editing Columns with trdsql
- trdsql Window Functions
- trdsql Date and Time Processing
- trdsql JSON parsing
- trdsql JSON output
- trdsql difference, comparison
- trdsql graph
- trdsql library
- trdsql SQL file
- trdsql config
- trdsql CROSS JOIN
- trdsql generate_series
- trdsql convert log
- trdsql Add total to the row
- trdsql CASE
- trdsql compress file
- trdsql output
- trdsql jq syntax
- trdsql For fixed width {class=“children children-type-flat children-sort-weight”}