DataGrip 2019.1

New DBMS support

• Greenplum is an analytics database based on PostgreSQL. It is currently developed by Pivotal and the open source community.
• Vertica is column-oriented storage designed to handle large volumes of data.
• Apache Hive is a data warehouse built on top of Apache Hadoop for providing data query and analysis.
• Snowflake is a cloud-based data-warehouse. In 2019.1 DataGrip supports only SQL dialect, the introspection support comes later.

Connection dialog

• General
  • Re-arranged the fields here to make the connection process more user-friendly.
  • The Connection type field is what used to be URL type. It determines the whole UI of this dialog, which is why it’s now on top along with the driver chooser.
  • The Database field goes after the credentials because sometimes credentials are needed to provide the database list. The list should be invoked by Ctrl+Space
  • Password saving is now implemented via a drop-down. It has four options: Never, Until restart, For session, and Forever. For Session is probably the only option that requires some explanation: it will save your password until you disconnect from the data source.
  • The empty password now can be set via the UI; use the context menu to do that.
  • Test connection results are now inline and can be copied to the clipboard via a small dedicated button. The link to the troubleshooting page is also added.
  • Starting with 2019.1, the Test Connection button will not be disabled if there are no downloaded drivers. When you click Test Connection, DataGrip will offer you to download JDBC drivers.
• Options
  • Moved Read-only, Auto-Sync, and Transaction control settings here, from the General tab.
  • Newly introduced settings:
    • Run keep-alive query each N seconds will help you keep the connection alive. You can define the custom query in the driver settings for unsupported databases.
    • Auto-disconnect after N seconds. Pretty self-explanatory.
    • Startup script is an SQL query which will be run each time you establish a connection. Remember that if Single connection mode is unchecked, each new console creates a new connection.
  • Renamed setting:
    • Warn if editing an outdated DDL is the new name for what used to be Notify when the outdated object is opened.
• Schemas
  • Object filter has been transferred here from the Options tab.
• Data source list
  • A small enhancement: DDL data sources now have their own group in the data source list inside the connection dialog.

Search and navigation

• Recent Locations - There’s a new Recent Locations popup that lists your recently visited/changed code locations. It presents them as code snippets with a couple of lines before and after the location. This popup was inspired by Recent Files, but with an ability to search by visited code locations. This should come in handy when you remember what the code was about but can’t recall where it’s located. Especially if you work with several query consoles: they usually have similar names. Press Delete/Backspace to remove locations from the popup. The default shortcut for this popup is Ctrl+Shift+E.
• Find in path - DataGrip can search in source codes of the objects. This was available only if you chose the All Places scope. Cleaned up this UI a little bit and removed the Module and Project tabs. A new scope, Attached Directories, is available. Use it if you want to search through files in the Files tool window.
• Go-to popup - All navigation actions now work from here. Also, don’t forget about Navigation settings in Database | General. Feel free to create your own flow, as DataGrip now probably covers all possible use cases.

Code insight

• Combined items in completion - Added some combined options to the completion list for CREATE and DROP statements. For example, when you start typing CREATE, you can select CREATE TABLE. One more benefit is that you can use abbreviations.
• New inspections
• Usages of GOTO statements and Named arguments should be used inspections are turned off by default as only some developers want these things to be reported. Usages of GOTO statements inspection has three options:
  • Report all GOTO statements;
  • Report uses of GOTO statements to exit a loop;
  • Report backward GOTO statements;
• Named arguments should be used. Some developers prefer that because it makes code more readable.
• DataGrip will also warn you if the cursor you use is not opened when inside a procedure or function.

Working with files

• Now there is a Default Directory option in Settings/Preferences | Appearance & Behavior | System Settings. It will define where your new project will be created by default.
• The Save as… action for the console file:
  • 1. Offers the default project directory.
  • 2. Keeps the last chosen folder.
• A new action, Detach directory, is available for folders in the Files tool window. Use it from the context menu or assign a shortcut.
• You can format files from the context menu without opening them.

Database tree view

• Improved database introspection for IBM DB2. You should now see the following new objects in the database tree: trigger, method, module, data type, variable, condition, sequence, check constraint, role, and global temporary table.
• The tree now saves the context by itself, so you’ll always see the data source name at the top.
• Added icons for some databases DataGrip doesn't support yet. Before, if you had many data sources of unsupported databases, they could all make a mess in the Database tool window.
• You can use any of the new custom icons for all the rest. Choose the icon on the Options tab of the driver’s settings.

Other

• Customizable themes
  • This release adds the possibility to fully customize the appearance of the IDE as now you’ll have the power to design your own theme from scratch. Created a few brand new themes to get you started. They can be downloaded as plugins. You can literally change the color of anything. Create your own theme plugin using the DevKit and modify the IDE appearance via a JSON file. Here are some links that you may find useful:
• Data editor
  • The filter is now a little nicer as it offers to use values from the clipboard.
• Definer support
  • Added support for the DEFINER attribute in MySQL and MariaDB.
  • First, you can choose whether the SQL Generator should add a DEFINER attribute to the generated code.
  • Second, you may ignore DEFINER attributes during migration.