vscode + clickhouse-client: poorman integration

gistfile1.md

1. File->Preferences->Settings terminal.integrated.scrollback, Increase the buffer size for terminal (i use 100000)

2. File->Prefernces->Keyboard shortcuts workbench.action.terminal.runSelectedText set up some binding like Ctrl+Shift+'

3. Open terminal window: Terminal->New Terminal

4. Run clickhouse-client in a terminal.

5. Highlight the query & hit the shortcut (or use Terminal->Run Selected Text)

Result:

perfect useful

great approach for minimalists, thanks!

Great idea, some possible improvements:

Run query at cursor

Assuming blank lines between queries (prettier-plugin-sql seems to work fine), try this keybinding to run the query at current cursor position:

  {
    "key": "cmd+enter",
    "command": "runCommands",
    "when": "editorTextFocus && editorLangId == 'sql'",
    "args": {
      "commands": [
        { "command": "cursorMove", "args": { "to": "prevBlankLine" } },
        {
          "command": "cursorMove",
          "args": { "to": "nextBlankLine", "select": true }
        },
        { "command": "workbench.action.terminal.runSelectedText" }
      ]
    }
  }

Disable wide tables wrapping

alt+z in terminal disables wrapping