No more Excel or Google Sheets. With Superintendent.app, you can use SQL to query and visualize gigabytes of CSV files on your local machine. Superintendent.app is an offline desktop application and protects your data privacy.
Csvq is intended for one-time queries and routine processing described in source files on the amount of data that can be handled by spreadsheet applications. It is not suitable for handling very large data since all data is kept on memory when queries are executed. There is no indexing, calculation order optimization, etc., and the execution speed is not fast due to the inclusion of mechanisms for
Additions: Numeric values are automatically recognized in more cases. Date / Time / DateTime values are automatically recognized in reasonable formats. See Time Strings for a list for accepted formats, and how to convert from other formats. Added join support! Multiple files / directories can be loaded by listing them at the end of the command. Directories are read by reading each file inside, and
trdsql is a CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN files. This tool is similar to others such as q and textql, with a key distinction: it allows the use of PostgreSQL or MySQL syntax. For usage as a library, please refer to the godoc and the provided examples. INSTALL 1.1. go get 1.1.1. Requirements 1.2. Download binary 1.3. Homebrew 1.4. MacPorts 1.5. FreeBSD 1.6.
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く