3 ms·
I am currently evaluating dsq and its partner desktop app DataStation. AIUI, the developer of DataStation realised that it would be useful to extract the underl
by sjellis 4y ago
I am currently evaluating dsq and its partner desktop app DataStation. AIUI, the developer of DataStation realised that it would be useful to extract the underlying pieces into a standalone CLI, so they both support the same range of sources.
dsq CLI - https://github.com/multiprocessio/dsq https://github.com/multiprocessio/dsq
DataStation desktop app - https://datastation.multiprocess.io/ https://datastation.multiprocess.io/
Two alternative CLI tools that I looked at:
sq - https://sq.io/ https://sq.io/
octosql - https://github.com/cube2222/octosql https://github.com/cube2222/octosql
Honourable mentions to:
Miller - https://miller.readthedocs.io/en/latest/index.html https://miller.readthedocs.io/en/latest/index.html
Dasel - https://daseldocs.tomwright.me/ https://daseldocs.tomwright.me/
These don't use SQL.
VisiData is also amazing for data navigation, although it requires some effort to get the model:
https://www.visidata.org/ https://www.visidata.org/
- alserio 4y agoxsv is invaluable for processing big csv files: https://github.com/BurntSushi/xsv https://github.com/BurntSushi/xsv