6 ms·
What's the quickest way to query a simple CSV file with SQL ? Interested in any gui or cli tools.
by dbeley 7y ago
What's the quickest way to query a simple CSV file with SQL ? Interested in any gui or cli tools.
- cgarvis 7y agonot sql, but xsv is awesome: https://github.com/BurntSushi/xsv https://github.com/BurntSushi/xsv
- hoistbypetard 7y agoIf you're accustomed to windows/office you can just set up a CSV as an ODBC data source and use access. Otherwise [csvkit](https://csvkit.readthedocs.io/en/latest/ https://csvkit.readthedocs.io/en/latest/) gives a pretty good command line interface to make sql queries against a CSV or dump the CSV into a database so you can use any standard database tool to query.
- slowhand09 7y agoIn Oracle I 'd just set up an External Table. Trivial to do.