ProHoster > Blog > Administration > DataGrip 2019.1: support for new databases, initialization scripts, new inspections and more
DataGrip 2019.1: support for new databases, initialization scripts, new inspections and more
Hello! Let's look at the new stuff in - Data Grip 2019.1. Recall that the DataGrip functionality is included in our other paid IDEs, except for WebStorm.
Support for new bases
In this release, four databases at once received official support in our tools:
Apache Hive is a database management system based on the Hadoop platform. Greenplum β analytical DBMS for data warehouses based on PostgreSQL. Vertica β column base for big data analysis. Snowflake - cloud storage. If we talk about relational databases, then Snowflake asked the most. In this release, we only supported SQL, we will release the instreption later.
Connection
We have made changes in the database connection dialog box: we have tried to make it more understandable and convenient.
General
In this tab, basically, there was a refactoring.
Field Connection type used to be called URL type and it was at the bottom. But, since the value in this field determines the further process, now it is at the top.
Field Database located after entering the login and password, because authentication is needed in order to display the list of databases by Ctrl/Cmd+Space.
Commenting on a previous post discussed a lot password saving. Added new options and made a drop-down list. The values ββof this list are:
Do not save password.
Save until DataGrip is restarted (previously, the βdo not saveβ option worked this way).
Keep per session: until you disconnect from the data source.
Perpetuate.
To avoid confusion, enter an empty password through the context menu.
The results Test Connection are now shown in the window itself, no extra clicks and dialogs.
And if the drivers are not downloaded, DataGrip will offer to do it. Formerly button Test Connection was in this case blocked, which confused users.
Options
Settings moved here from the General tab Read-only, auto sync, transaction control.
New:
- Run keep-alive query every N seconds: will poke the data source every N seconds. For databases that we do not support, you can write a keep-alive request yourself. This is done in the driver settings.
- Auto-disconnect after N seconds: The value in seconds entered here will tell DataGrip how long to automatically disconnect from the data source.
- Startup script: Here you can enter a query that will be executed every time a connection is created. Recall that if single connection
Fashion not enabled, a new connection is created for each new console.
schemas
The filter of objects displayed in the tree has moved here.
Navigation and search
List of recent locations
The new Recent locations window shows you where you've been recently. List items are small pieces of code that you have recently edited or viewed. This is useful if you remember the context but don't remember the file name. This often happens in DataGrip because all consoles are named similarly π The default keyboard shortcut is: Ctrl/Cmd+Shift+E.
If you previously used this keyboard shortcut to display a list of recently modified files, now please double-click Ctrl/Cmd+E.
Path search
We removed unnecessary options that we βgotβ from the platform: Modules ΠΈ Project. Now by default Find in path in DataGrip searches everywhere. Also added a new search area attached directories - it includes only files and folders from the Files panel.
Actions from navigation results
Actions now work from navigation results that are applicable to objects in the code or tree. For example, you are looking for a table. Here's what you can do from the results window.
View DDL: Ctrl/Cmd+B.
Open data: F4.
Open the Modify Table window: Ctrl/Cmd+F6.
Display in a different context: Alt + F1 (for example, show in a tree).
See general information: Ctrl+Q/F1.
Generate SQL: Ctrl/Cmd+Alt+G.
Working with code
Combined elements in autocompletion
For CREATE ΠΈ DROP autocomplete offers combined options.
Don't forget about abbreviations.
New Inspections
DataGrip will warn you if you are using a cursor that you have not opened.
The next two inspections are disabled by default, but some may need them.
If you use unnamed arguments, this will be highlighted.
An inspection that swears at the GOTO statement.
Work with files
Added a setting for the default project folder. New projects will be created in this folder.
Action Save as... for console now:
Suggests a default project folder.
Remembers the last choice.
Added an action to the file tree Detach Directory: Unpin a folder. Previously, to unpin a folder (that is, not to show it in this tree), you had to click Delete, and DataGrip was asking: Do you want to delete or unpin? It was inconvenient and incomprehensible π
Database Tree
We have written our own introspection for DB2. This means that we get information about database objects using queries, and not through the JDBC driver, as before. Thus, objects that did not exist before appeared in the tree: triggers, types, methods, modules, counters, roles, and others.
The tree stores the context: the name of the data source sticks on top.
Icons were drawn for unsupported databases: those who have data sources created for such databases will no longer get confused.
We also drew abstract icons, they can be used in the driver settings.
Rest
Custom themes
DataGrip users got the opportunity to make any color scheme. The new scheme is a plugin that must be installed from the section Plugins in settings.