How much does DataGrip

DataGrip 2019.2 offers a full text search

After the all-round blow in the development environments for various programming languages, JetBrains now also presents the database IDE DataGrip in version 2019.2. The release brings some innovations that serve for a better overview and easier administration. A noteworthy convenience function is the new full-text search via various data sources.

All JetBrains IDEs, including the IntelliJ IDEA, WebStorm and PHPStorm, which were updated in mid-July, bring an overview of the services in the 2019.2 release in a new tool window that can be accessed via Alt | 8 opens. In DataGrip it shows an overview of all connections in a tree view with the associated data sources. A green dot marks active connections that can be closed using a context menu. In addition to connections that start a query, the overview shows the time required for this. If you don't want the tree view, you can replace it with the old one.

Easier search

An interesting new feature, which primarily serves to improve convenience, is the full-text search. The keyboard shortcut Ctrl | Old | Shift | F opens a window in which, in addition to the search query, the data sources and column types to be taken into account can be specified. Another field specifies how many results the query should output. A preview shows the SQL query resulting from the search.

DataGrip then shows a tree structure with the data sources that contain hits and the respective number of search results. Clicking on a source opens it in a table view. DataGrip takes into account some special features of individual databases and columns in the full text search. In this way, it can also cover JSON types, which DataGrip first converts into strings, since JSON fields cannot be searched with the operator. Cassandra potentially requires multiple queries because it lacks the link.

Hidden metadata

DataGrip uses the system catalogs of various databases such as and in PostgreSQL, in SQL Server, and in Oracle or in MySQL for aids such as auto-completion. Previously, to access the schema metadata, the IDE had fully loaded the catalogs for each database and displayed them in the database explorer. Developers can now select which catalogs DataGrip checks completely and shows in the overview. The others are only used by the IDE to help create code.

The data editor also brings a few new features that provide a better overview. The page size can now be determined with a drop-down menu, and developers can give the result tabs the name with the results by inserting a comment in front of the query.

Further innovations in DataGrip 2019.2 such as the creation of groups via drag-and-drop and updating via the Force Refresh menu item can be found on the "What's New" page of DataGrip. JetBrains offers all IDEs in a subscription model, with the price dropping within the first three years. DataGrip costs 89 euros in the first year and 53 euros per user from the third year onwards. Unlike IntelliJ IDEA, there is no free version for DataGrip. (rme)

Comment on the post
Ad ad