dbcli / mycli

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.
http://mycli.net
Other
11.39k stars 657 forks source link

Combine mycli with sc-im #599

Open nanangarsyad opened 6 years ago

nanangarsyad commented 6 years ago

First of all, thanks for creating this great tool. I also quite love how interactive and Xsever-less mycli works. Ok, I'll get to the point, I wanted to combine mycli and sc-im. The current viewer of mycli seemed a bit hard to graps if the query gave a long column. So if possible I would like to using sc-im to view the query result.

By the way, I got this idea from this simple python script but nice, and in short that script trying to show numpy, and few more python data objects in sc-im.

Thank you.

meeuw commented 6 years ago

sc-im looks lovely, this can already be done by using the pager and the tsv output. use the following script

#!/bin/bash
TEMP=$(mktemp -d)
cat > $TEMP/output.tsv
/path/to/scim $TEMP/output.tsv
rm -rf $TEMP

(write this to a file and make it executable)

Then use the following command in mycli

pager /path/to/above/wrapper.sh
\T tsv

Then if you execute a query sc-im should popup and show the data.

nanangarsyad commented 6 years ago

wow, it works like a charm :tada: It's quite good if used in terminal with small dimension. Thank you :smile:

Here's some sample mycli-scim