DataGrip 2020.3 EAP is Started!
For those of you who are eager to try the newest things, we invite you to join our Early Access Program for DataGrip 2020.3. As you may know, these builds don’t require a license – we just want everybody to try the new features out before the official release. Let’s go!
We’re always happy to welcome a new database into our family, and our newest member is Couchbase! It’s important to mention that DataGrip supports the Couchbase Query service, not the Couchbase Analytics service.
The most important enhancement in this aspect is that DataGrip now knows about object grants and displays them in an object’s DDLs. It works for MySQL, PostgreSQL, Greenplum, Redshift, and SQL Server.
[PostgreSQL] More properties for tables
DataGrip now generates DDLs with TABLESPACE and INDEX ACCESS METHOD.
[Greenplum] New objects
Now DataGrip shows more objects in the database tree. The new objects are: collation, materialized view, foreign table, foreign data wrapper, foreign server, and user mapping.
[Oracle] Correct display of overloaded procedures
The overloaded procedures in one package used to be displayed as one item. That’s no longer the case.
Changes in the database tree
If you’ve changed the DDL of some objects but haven’t submitted them yet, the objects waiting to be submitted are highlighted in the database tree. Previously you could only see them in the Database Changes tool window.
Separate editor for cell values
We’ve improved the separate editor for cell values that we introduced in 2020.1.
It now can display the formatted value even if the value is not formatted properly. Moreover, you can edit the value in the formatted view and update it with the original formatting. This works with one-line XMLs and JSONs.
If the width of the screen is crucial to your flow, you can move the cell value editor to the bottom of the data editor.
This panel can now also display images!
For a long time now, the expand selection action could be used in tables. It should be invoked by Ctrl+W in Windows and Linux and Opt+Up in macOS. Now we have added the opposite action: shrink selection. The shortcut is Ctrl+Shift+W on Windows and Linux and Opt+Down on macOS.
Opening transposed tables
We’ve added the ability to open tables and views in the transposed view by default. It can be useful if the average table in your database has an enormous number of columns.
Introducing two new extractors!
One-Row will help you to copy a column to a comma-separated string. This can be extremely useful for pasting a set of values in an IN clause!
SQL-Insert-Multirow will generate a signle INSERT statement with multiple new rows to be inserted.
Now there is a new option in CSV format configuration: never quote values.
In-line renaming will now offer you options to work with comments and strings or text occurrences.
Alt+Enter now offers you options to fix typos without the need to open a nested menu.
We’ve introduced a new inspection for Oracle: if there is a call conflict when using an overloaded function, DataGrip will warn you about it:
[SQL Server] Hints for indexes in ‘Explain plan’
In the ‘Explain plan’ tool window DataGrip offers to create indexes for you if the database thinks it could help with the performance of the query.
The Welcome screen is back
Unlike other JetBrains IDEs, DataGrip has never had a Welcome screen. When you open DataGrip 2020.2 it will still take you straight to the last opened (or the default) project. But when you close all projects, a Welcome screen will appear. Here you can access all your projects, manage plugins, and customize the IDE.
Settings | Plugins now has options to enable or disable a plugin only for the current project. A plugin will be loaded automatically when the first project requiring the plugin is opened, and unloaded automatically when the last such project is closed.
Syncing current theme with OS settings
If the user selects Sync with OS in Settings | Appearance & Behavior | Appearance | Theme, the IDE will automatically switch to the light or dark theme when the OS UI makes the same change.
macOS shortcuts as words
If you are struggling to read the macOS shortcuts, try toggling ide.macos.disable.native.shortcut.symbols key in the registry. The registry can be invoked by Find Action Cmd+Shift+A and typing ‘Registry’ there.
That’s all for today. Your feedback is welcome in our twitter or forum. We also have a handy way for you to quickly report issues straight from DataGrip: click Help -> Report problem… to create a new issue in our issue tracker.