DataGrip 2016.1 Released!
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
Subscribe to Blog updates
Thanks, we've got you!
DataGrip 2023.2: New UI with toolbar icons in the header, AI Assistant, time zones in the data editor, support for Redis Cluster
DataGrip 2023.2 is out!Here’s a sneak peek at what it has to offer. For a detailed description of this update, please visit our What’s New page. User Interface New UI: The toolbar icons have been moved to the header Improved main toolbar customization Light theme with light …
DataGrip 2023.1 Quality Release
Hello! For DataGrip 2023.1, we focused entirely on quality. We’ve fixed many bugs that had accumulated in our public issue tracker (not the most fun part of the job, but important nonetheless). While there won’t be any new features for you to explore this time, we hope you’ll notice impr…
DataGrip 2022.3: Redis Support, Quick Filter In Database Explorer, Pattern-Based Schema Filtering, Formats for Datetime Fields, and More!
DataGrip 2022.3 is here! This is the third major update of 2022, and it’s packed with various enhancements. Let’s take a look at what it has to offer! For a detailed description of this update, please visit our What’s new page. General Redis SupportNew UI available via settingsNew Settings Syn…
DataGrip 2022.2: The option to import multiple CSV files, New Modify UI, Playground and Script resolve modes, and more!
Hello, We’ve just released the second major update of 2022. Here’s a list of all the improvements introduced in 2022.2. For detailed descriptions of all new features and enhancements, please visit our What’s new page. The option to import multiple CSV files You can now select several CSV fi…