News for hackers. Stuff that matters.

A comment on Command-line data analytics made easy. Parent comment

Re:Command-line data analytics made easy by mytherin on Thursday November 03, 2022 @08:47AM (#33450177)
You may also want to have a look at the DuckDB command line client [1]. The shell itself is based on the SQLite client, and DuckDB can be used to natively query CSV and Parquet files. Using extensions, DuckDB can also query SQLite and Postgres databases, and query files over HTTPS and S3.

The command line client also has some nifty features like syntax highlighting, and context-aware auto-complete that is coming in the next release.

[1] https://duckdb.org/docs/installation/

Disclaimer: working on DuckDB

[ Parent | on HN ]
Re:Command-line data analytics made easy by dmoura on Thursday November 03, 2022 @10:09AM (#33451240)
DuckDB is great! I love what you guys are building. The main gap for me is native support of JSON (lines), like you have for CSV and Parquet.
[ Parent | on HN ]
Re:Command-line data analytics made easy by Beltalowda on Thursday November 03, 2022 @12:11PM (#33453221)
One thing I really miss in the DuckDB is that it doesn't insert the entire query if you use C-p/Up arrow for multi-line queries (it just cycles through the lines of the query). This behaviour is inherited from SQLite, and it trips me up every time even after years of SQLite CLI usage.
[ Parent | on HN ]