RubyMine 5.4.3 Web Help

With RubyMine, you can query and modify configured data sources from the dedicated Database Console tool window using one of the supported languages:

You can either enter all the necessary commands in the Input pane of the console or prepare a file that contains commands in the desired language. In both cases, RubyMine provides code specific completion, syntax and error highlighting, and completion of the data source, table and column names.

RubyMine also supports operations with database binary large objects (BLOBs).

Tip

The Input pane opens as a new editor tab as soon as the Database console is invoked.

Retrieved records are shown in the Result pane, where you can view, analyze, and update them.

RubyMine opens connections to databases when necessary without any steps from your side and displays them below corresponding data source nodes in the Database tool window.

Tip

The SQL server should be running. You can create a special command using the external tools configuration facility, as described in the section Using Third-Party Tools.

In this section:

To launch the Database console
  1. Open the Database tool window.
  2. Select the desired data source.

    sqlSelectDataSource.png

  3. Right-click the tool window (any node or the background), and choose runJdbcConsole.png Open Database Console, or press Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+Shift+F10Ctrl+F9Shift+Alt+F6 or Shift+F6Ctrl+Shift+F10Shift+Meta+RControl Shift F10Control Shift F10Control Shift RAlt Meta F8. The Database console tool window for accessing the selected data source opens.
    • The Result and Output panes open as usual, in the bottom area of the screen.
    • The Input pane opens as a separate editor tab.

See Also

Procedures:

Language and Framework-Specific Guidelines:

Reference:

Web Resources: