DataGrip 2018.2

Hello! Please give a warm welcome to our new major release, DataGrip 2018.2!

Splash

Starting with this version, the database functionality of IntelliJ-based IDEs is available in CLion and AppCode. So if use one of these IDEs welcome to our blog :) Also, those who use WebStorm and DataGrip simultaneously can now install a database plugin inside WebStorm.

We thank all of the EAP contributors who have helped us by testing all the new features added in this release. Let’s have a look at what’s in there.

SQL log
New SQL formatter
Running stored procedures
Source code migrations
Query plan diagram
SQL editing
Data editor
UI upgrades

SQL Log

First, now you’ll see every query that DataGrip runs in the console output. Whether it’s your SQL or something DataGrip needs to run internally, check the Output tab to understand what’s going on.

SQLLogConsoleOutput

Second, literally all queries from the IDE are now logged in a text file.

SQLLogFile
To open this file, go to Help -> Show SQL log.

SQLLogShowInFinder

New SQL formatter

Thanks for sharing your ideas about SQL styles with us! We hope that now DataGrip will be able to accommodate many more different code styles.
The new SQL formatter is a feature we strongly need feedback on, so please try it out and if your specific cases are not covered, do let us know. We are still working on new clauses to add.

Formatter

As you may already know, you can create custom Code Style schemes.

ActionsOnCodeStyle

Now any of them can be used specifically for each data source. To do this, go to the Options tab of the data source properties.

SetCodeStyle

Running stored procedures

This long-awaited feature has been implemented for Oracle and PostgreSQL! Support for SQL Server procedures is only available in DataGrip for now, but will soon appear in the 2018.2.1 updates of other JetBrains IDEs.
Select Execute from the context menu of the procedure:

ExecuteProc

The SQL code will be generated. Put in the values of the parameters you need and click OK.

RunOracle

As you can see, we retrieve the output of this Oracle procedure because we have SQL code which fetches the result-set from the JDBC driver.
For situations when you run just a simple procedure with no output, DataGrip will generate SQL code by just running this procedure. Again, you’ll need to add the values to the parameters. Here’s a PostgreSQL example.

Untitled-3

Note that you can run the procedure by clicking the Run button in the toolbar when opening the source code.

Source code migrations

Now, to update the source code of any other objects, just double-click them and make the needed changes. The gutter (the vertical bar to the left of the text editor) will highlight the changes you’ve made. Note also the new Submit button on the toolbar.

MigrationButtons

After you click Commit, the migration dialog will show the generated SQL code to update the source code.

MigrationDialog

Query plan diagram

A diagram-based view is now available for the query plan.

ExplainGraphics

To view it, click the Show Visualization button on the toolbar after you invoke Explain Plan. As a reminder, it’s also available in the context menu for queries in the SQL console.

ExplainButton

SQL editing

Context info

When editing a huge procedure in a package, it is sometimes useful to refresh your memory on its context, i.e. what particular procedure or package is now being edited. To do this, press Alt+Q (Shift+Ctrl+Q for OSX) to see the context information:

Context

Jump outside closing bracket/quote with Tab

Starting with this version, you can navigate outside the closing brackets, or closing quotes, by pressing Tab. Note this works only when inputting parameters or values for the first time.

JumpOutside

To customize this behavior of Tab, go to Preferences | Editor | General | Smart keys and select Jump outside closing brackets/quote with Tab.

SmartKeysSetting

Data editor

Column comments in tooltips

Pretty self-explanatory :)

CommentsColumns

Number of selected rows

Now DataGrip shows the number of rows selected in the data editor. Look for this in the status bar.

Cells

UI upgrades

Touch Bar support

We’ve added support for the MacBook Touch Bar. It only has an Execute button by default.

TouchBar1270

To add actions, go to Preferences → Appearance & Behavior → Menus and Toolbars → Touch Bar.

TouchBarSetting

Assign a shortcut from Find Action

Previously, it was impossible to assign a shortcut from the Find Action if using the Default keymap. We’ve fixed this bug and now it works in any keymap and any layout. A good reason to remind you that it’s possible!

AssignShortcut

Custom data source

Now you can add custom data sources based on jdbc-driver. Click the + button on the toolbar and select the appropriate item from the drop-down.

Driver

Run SQL on a schema

Before, the only way to run the script was by executing it from the context menu of the corresponding SQL file. Now you can use a more intuitive way: choose the datasource or the database you need and select Run SQL script from the context menu.

RunSQLSCript

Dialect and console choosers

Now you can choose the dialect of the SQL file and attach any console to it just from the toolbar.

ChooseDialect

Dark window headers

Now you can make the Darcula theme even darker. If you are on a macOS, to darken the title bars, just go to Preferences → Appearance & Behavior → Appearance and select Use dark window headers.

DarkHeaders

Important bug fixes

DBE-6681: MySQL comments are being formatted properly.
DBE-5204: DDL for a table opens in a right place.
DBE-1858: Deleting the criteria from the Filter field shows all rows in the data editor.
DBE-6436: Backspace doesn’t break quick search in Structure View.
DBE-6362: Views with no schema binding in Redshift are shown in the database tree.
DBE-6469: Record count in data editor works if sorting applied.
IDEA-189650: IDE opens empty files after restart.

The only thing left to do now is to grab your 30-day trial of DataGrip.
Don’t forget about twitter, forum, and the issue tracker.
Your DataGrip Team
_
JetBrains
The Drive to Develop

This entry was posted in Releases and tagged . Bookmark the permalink.

12 Responses to DataGrip 2018.2

  1. Eugene says:

    Hi. I’ve just updated to 2018.2, but I have no “Use dark window headers.” in Appearance

  2. Jim Katz says:

    Need a roadmap for Routine editing and executing in MySQL.

  3. Сергей says:

    Возможно ли волонтерское тестирование программного продукта DataGrip вне штата?

    • Maksim Sobolevskiy says:

      Что вы имеете в виду? :) Что вы подразумеваете под тестированием и чем оно отличается от использования?

  4. Daniel Ems says:

    I’m glad to see the SQL Log feature. It’s one of the things that held me back from using DataGrip.

    Atlantis SQL Everywhere and SSMSBoost have this feature with the ability to search by date range. Any chance that will be added to DataGrip?

    Can you change the location of the SQL Log file?

    • Maksim Sobolevskiy says:

      1. How this search should be implemented? And why not using SQL for that?
      2. It’s impossible now, I am sorry.

  5. has Query plan diagram feature been implemented to all relational database? I use to connect mysql database and I can find Show Visualization button.

Leave a Reply

Your email address will not be published. Required fields are marked *