• overview
  • table of contents
  1. Top > 
  2. trdsql

trdsql

Posted on: April 24, 2024
Download

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 column2 columns
1 rowa1a2
2 rowb1b2

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
Apr 24, 2024
LogoNoboru Saito’s site
  • Home

  • Blog
    • trdsql v1.0.0
    • trdsql v0.13.0
    • ov v0.32.1
    • trdsql v0.12.1
    • trdsql v0.12.0
    • ov v0.32.0
    • ov v0.31.0
    • psqlのPAGERを設定する
    • ov v0.30.0
    • Guess the width of the width-specified format
    • trdsql v0.11.1
    • ov v0.15.0
    • ov v0.14.2
    • ov v0.14.1
    • ov v0.14.0
    • ov v0.12.0
    • PostgreSQLで0列の扱い
    • ov v0.11.1
    • ov v0.11.0
    • 手っ取り遅くSQLを学ぶ
    • Another way to aggregate json(jq + SQL)
    • trdsql v0.10.0
    • 第32回 PostgreSQLアンカンファレンス@オンラインで発表しました
    • ov v0.10.0
    • trdsql v0.9.1
    • ov v0.9.6
    • Jpug-doc-tool
    • ov v0.9.5
    • trdsql+PostgreSQL 14でJSONを処理する
    • ov v0.9.4
    • mdtsql v0.0.3
    • pgsp
    • trdsql v0.9.0
    • ov v0.9.0
    • ov v0.8.1
    • trdsql v0.8.0
    • ov v0.8.0
    • goのTUIについて2020年最終版
    • ov v0.7.0
    • SQLのORDER BY 列番号と式
    • tcell/tviewでTUIを作るならキー割り当てにcbindを利用しよう
    • ov v0.6.2
    • ov v0.5.0
    • ov v0.2.0
    • tcellについて2
    • tcellについて
    • goのTUIについて
    • ov v0.1.3
    • ov
    • GoのTUIで表示が崩れる場合
    • trdsql 0.7.5
    • MySQL の LOAD DATA INFILE (go)
    • trdsql 0.7.4
  • trdsql
    • 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
  • ov
    • psql
    • git
    • delta
    • mysql
    • pgcli
    • mycli
    • ps
    • man
    • top
    • procs
    • bat
    • watch files with ov
    • view csv
    • view markdown
    • multiple files
    • multicolor highlights multiple words
    • speed of opening large files
    • tailspin
    • execute command
    • how to use follow mode
    • filter search
    • vertical header and header column
    • how to use section
    • hide other sections
    • memory management
  • About
  • Categories
  • Tags

  •  
  •  
  •  

GitHub

Built with by Hugo