Hacker News new | ask | show | jobs
by eatonphil 1201 days ago
Welcome to the gang! :)

https://github.com/multiprocessio/dsq#comparisons

Realistically though aside from the variety of input formats that DuckDB doesn't (yet) support, I think most people should probably use DuckDB or ClickHouse-local. Tools like dsq can provide broader support or a slightly simpler UX in some cases (and even that is obviously debatable). But I think the future is more the DuckDB or ClickHouse-local way.

dsq may end up being a frontend over DuckDB some day.
1 comments
snthpy 1199 days ago
I made a docker image with a number of extensions already installed and enabled so you can start using DuckDB with the lowest friction.

`alias dckr='docker run --rm -it -v $(pwd):/data -w /data duckerlabs/ducker'`

then `dckr` gives you a DuckDB shell with PRQL, httpfs, json, parquet, postgres, sqlite, and substrait enabled.

For example, to get the first 5 lines of a csv file named "albums.csv", you could run it with PRQL

```dckr -c 'from `albums.csv` | take 5;'```

https://github.com/duckerlabs/ducker

link