herrfugbaum / qsv

Process CSV and TSV files with SQL.
MIT License
13 stars 5 forks source link

Large tables rendering #21

Open herrfugbaum opened 5 years ago

herrfugbaum commented 5 years ago

Describe the bug If a table has many columns or if the console window isn't large enough the tables will render quite clunky.

To Reproduce Steps to reproduce the behavior:

  1. qsv -p path/to/file
  2. SELECT * FROM test

Expected behavior Tables should look like tables

Screenshots Result: 04-12-_2018_09-28-26

Result with a wider terminal: 04-12-_2018_10-08-07

Software Versions (please complete the following information):

Additional context Probably this can be tackled by configuring table correctly

ankush981 commented 5 years ago

How about adding a \G option to display rows vertically, the way MySQL does? I don't think any amount of formatting can save us, as some files can have 100s of columns. :thinking:

herrfugbaum commented 5 years ago

Good call! I have to take a closer look on this.

I think it's a good idea to do both, so we can see as many columns as possible without the need to use the \G switch.