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.
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:
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):
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.
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 DataGrip Team
The Drive to Develop