DataGrip 2016.1 Released!

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.

DataGrip2016_1_splash

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…”:

CopyFromSSH

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:

URLTemplate

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

NewURLTemplate

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:

UnresolvedPortMSSQL

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.

ConnectionCompletion

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:

MySQLConnectivity

Editor

Welcome new intentions, Qualify identifier and Unqualify identifier:

quote

Now DataGrip displays common table expressions in Structure View:

structureview

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):

arabic

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 applya virtual folder, so to speak.

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

ScopesOptions

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

ScopesFiles

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.

wordbyworddif

PostgreSQL support

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

withingroup

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:

functionqualifies

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:

indexresolve

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

 

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

8 Responses to DataGrip 2016.1 Released!

  1. Stewart says:

    Still can’t get DDL for Views.. instead of a “Create View” – its a Create Table….

    About time to support DDL for Views?

  2. Mike says:

    Great news.
    What about NoSQL DBs support, such as MongoDB, GraphDB, Cassandra and others?

    For the moment, JB’s IDEs (IDEA and others) have no native out-of-box support of MongoDB. The existing Mongo Explorer plugin has very limited functionality, low stability and poor usability. It will be great to be able to manage such DBs directly from JB’s IDE without external third-part tools.

    • Maksim Sobolevskiy says:

      No such plans for now, Mike. We know, there are many people who ask for NoSQL support and we discuss it, but we have so many things to implement. So, one day, but not in closest future.

  3. T says:

    looks like it doesn’t support MsSql LocalDb? or it’s just giving me hard time connecting to localdb?

  4. Pingback: A very important security update: DataGrip 2016.1.1 | JetBrains DataGrip Blog

Leave a Reply

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