DataGrip 2016.1 Released!

Maksim Sobolevskiy

Hello!

Like all other desktop products from JetBrains, DataGrip is switching to the new versioning scheme. So please give a warm welcome to the next release, DataGrip 2016.1.

For those of you who were curious and impatient to try the newest things in this update, we did open an EAP program a month ago. We thank all of the EAPers who helped us by test-driving all the new features we added in DataGrip 2016.1. Let’s have a look at them.

Connectivity

We’ve improved the interface for using the SSH tunnel.

SSH/SSL tab is not hidden anymore depending on the driver—you can always see it. As you may know, you can copy SSH settings from some other data source. Now the password is copied as well, so you don’t need to do anything else except selecting  “Copy from…”:

We’ve added a new warning to alert you if a URL can’t be parsed. This is likely to happen if you use some DBMS we don’t directly support:

This problem can be fixed by clicking “create template”. You will be offered to create your own template for JDBC URL:

We now have new inspections for SQL Server connection. Some of our users had difficulties with it, often because they specified the wrong port number. Now DataGrip will inform you about this situation. Specify the correct port number by clicking Apply near the Instance field:

In the General tab for SQL Server data source, now there is completion for hosts, instances and databases. Thus, you can see the complete list of what you need by pressing Ctrl+Space in the text field.

We improved the way MySQL tells you about the errors in connection. Before, it was just “Could not create connection to database server. Attempted reconnect 3 times. Giving up.” Now, for instance, if user or password is incorrect, you will know about it:

Editor

Welcome new intentions, Qualify identifier and Unqualify identifier:

Now DataGrip displays common table expressions in Structure View:

Starting with this version, Structure View can show long names without shortening them in an unpredictable way.

Also, we’ve added support for Right-to-left languages (Arabic, Hebrew):

IDE

Starting with this version of DataGrip, you will be able to use file scopes, which are familiar to some IntelliJ IDEA users. Scope is a set of files to which various operations apply—a virtual folder, so to speak.

To manage scopes, go to Preferences/Settings → Appearance and Behavior → Scopes.

Then you will be able to see scopes in the Files panel (Ctrl/Cmd + 2).

We’ve added by-word difference highlighting in the diff viewer — now it’s easier to clarify the distinction between two files. Don’t forget that you can use diff viewer to compare two versions of the script in local history.

PostgreSQL support

Some PostgreSQL features like WITHIN GROUP and window functions for custom aggregates are now properly highlighted and available for completion:

We improved support for table functions: now they’re highlighted and available for completion. Automatic aliases can be used for qualification and are no longer a problem for the SQL editor:

Also, we’ve added support for functions in indexes: you can navigate to them in the database view just from the index DDL, by clicking them while holding Ctrl/Cmd:

Other fixes and enhancements in this release include:

• Oracle 12 grammar support.
• Moving elements in XML left or right with Alt+Ctrl/Cmd+Shift+Arrow keys.
• Objects that are not introspected now can be resolved to DDL statement is there is any.
• Ctrl/Cmd+F text search in Terminal plugin.
• Fix for the issue of losing the formatting of Oracle functions and procedures.
• Remote Hosts Access plugin is available for installation.

That’s it! Get your 30-day trial of DataGrip today if you haven’t before, or just enjoy new features of DataGrip if a happy user of ours already.

Your feedback is welcome in our twitter, forum and the issue tracker. Let us know what you think!

Your DataGrip Team
_
JetBrains
The Drive to Develop

Subscribe to DataGrip Blog updates

Subscribe form

By submitting this form, I agree to the JetBrains Privacy Policy Notification icon

By submitting this form, I agree that JetBrains s.r.o. ("JetBrains") may use my name, email address, and location data to send me newsletters, including commercial communications, and to process my personal data for this purpose. I agree that JetBrains may process said data using third-party services for this purpose in accordance with the JetBrains Privacy Policy. I understand that I can revoke this consent at any time in my profile. In addition, an unsubscribe link is included in each email.

Submit

Thanks, we've got you!