JetBrains DataGrip 2019.2.6 [En]

Exploring your databases

DataGrip is the multi-engine database environment. If the DBMS has a JDBC driver you can connect to it via DataGrip. It provides database introspection and various instruments for creating and modifying objects for the supported engines:
Database objects
DataGrip introspects all objects in your databases and displays them in folders grouped by schemas. It also provides a UI for adding and editing tables, columns, indexes, and constraints etc.
Data editor
The powerful data editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the data editor.
Navigation
Quick navigation takes you to an object independent of whether it has just been created in your code, or it has already been read from a database. Navigate to symbol action lets you find objects by their name.

---

Writing SQL

Just as any decent IDE should, DataGrip provides smart code completion, code inspections, on-the-fly error highlighting, quick-fixes, and refactoring capabilities. It saves you time by making the process of writing SQL code more efficient.
Smart text editor
Just as with any IntelliJ platform IDE, DataGrip includes a code editor which helps you be more productive. Transform and move blocks of code, use multi-cursors to manage selection, format code according to a specific style, and much more.
Code completion
DataGrip provides context-sensitive, schema-aware code completion, helping you to write code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in the code you're editing.
Code generation
Forget about writing typical code manually: DataGrip will do that for you. It generates code for changing objects like tables, columns, etc., based on UI. Moreover, it helps you to get DDL for tables and provides DML queries from result-sets.
Code analysis and quick-fixes
DataGrip detects where probable bugs may occur in your SQL code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, the use of keywords as identifiers, and always offers you a way to fix the problem.
Refactoring and finding usages
DataGrip correctly resolves all references in your SQL files. When you're renaming database objects from SQL, they will also be renamed in the database. You can quickly find in which stored procedures, functions and views your tables are used.
Customize appearance
DataGrip comes with light and dark look and feel themes. Each of them can be fully customized, so you can create the one that suits you best. The same works for more than ten pre-configured keymaps.

---

Running queries

The query console in DataGrip is a basic necessity for any SQL developer. Create multiple consoles, each with their own schema and query options.
Query console
Specify the console’s behavior for running queries: choose what you want to execute— from the smallest statement or the largest one.
Local history
Each console supports schema switching, and provides a local history to keep track of all your activity protecting you from losing any of your work.
Diff viewer
Use the diff viewer to compare two console snapshots in local history or two query results. DataGrip highlights the differences between the two and lets you manage the level of the comparison criteria via a tolerance parameter.

---

Import/export options

Import data from CSV or any DSV file. DataGrip also has a powerful engine to export data in various formats. You can even create your own export formats.
Import CSV
Enjoy a dedicated UI for importing CSV and TSV files to the database. It’s possible to map every column of the file being imported to a table column in your database, which can be either an existing table or a new one created during the import process.
Export as text
Any table or result-set can be exported in a variety of formats including CSV, JSON, XML, and HTML. You can even create your own export format.
Export as queries
Any table or result-set can also be presented as a batch of UPDATE or INSERT statements, which can be helpful for modifying data.

---

Miscellaneous features

Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features.
User parameters
DataGrip supports running parameterized SQL queries. Add your own parameter patterns using regular expressions and choose the SQL dialects which these patterns will be applied to.
VCS support
DataGrip provides a unified interface for most of the popular version control systems, ensuring a consistent user experience with Subversion, Git and GitHub, Mercurial, CVS, Perforce, and TFS.
Diagrams
Explore your tables and their relationships on an insightful diagram.

Services tool window

All our IDEs now have a new tool window called Services. In DataGrip, you can observe and manage all the connections there.
Every connection has its own node under the corresponding data source. If the small green light on the icon is on, it means that the connection is live. You can easily close a connection by using the context menu.
You can view all the service types as nodes, or alter the view to see them as tabs. Use the Show in New Tab action from the toolbar, or simply drag the node you need onto the title bar of the Services tool window.
The query result is now attached to the particular console under its connection in the Services view.
Important! The default shortcut for Services tool window is Alt+8

Hiding the tree
If you don’t want to see the Services tree (that is, you want to go back to how it was before), click the gear icon and hide it.
QUERY LIVE TIMER
The Services tool window also provides you with another requested feature: a query live timer. For any connection that runs a query, look to its right-hand side to see how much time it took.
Docker
If you use the Docker plugin, the corresponding services will also appear in this tool window.

---

Full-text search

Now you can search for data even if you don’t know where it is located. To do this, select the data sources, groups of data sources or even separate tables you want to search through and invoke Full-text search from the context menu. Of course, there is a shortcut for this as well: Ctrl+Alt+Shift+F.
You will see a dialog to enter the string into. You will see the list of data sources to search through, and you’ll be able to set some options for your search.
In addition, you can see which particular statements DataGrip will run to perform the data search.
After running the search, you’ll see the results which you can open.
Click on a result to open the data editor. The filter will be pre-defined to give you only those strings where the data is found. If you cannot locate the data because there are too many columns, use text search in the data editor with Ctrl+F.
- In some databases you can choose to search only in columns that are indexed. To use this mode, select Only columns with full-text search indexes in the Search in drop-down menu.
In PostgreSQL, the query will be: where col @@ plainto_tsquery('text').
In MySQL and MariaDB, the query will be: where match(col) against ('text' in natural language mode).
In Oracle, the following indices are used, if they exist: context, ctxrule, ctxcat.
In SQL Server, if there are columns with fulltext indexes, DataGrip generates queries with WHERE CONTAINS(col, N'text').
In SQLite, DataGrip generates queries with where col MATCH ‘text’.
- If All columns mode is selected The search will look in columns that don’t support the LIKE operator, for instance, columns of JSON type. Values in these columns are converted to string beforehand.
- In Cassandra, DataGrip creates several queries for one table, because the OR condition isn’t supported by the database.

---

Data editor

The page size is easy to change
Now, to define how many lines you want to retrieve from the database, you can do it from the result-set’s toolbar.
The results tabs can be named
Another super-cool improvement for results: tab naming! Just use the comment before the query.
If you only want certain comments to become tab names, use the Treat text as title after field in the settings to specify the prefix word. Then only the words coming after that word will be used as titles.

---

Database tree view

Quick table backup
It was possible to copy tables via drag-n-drop, but it didn’t work when copying to the same schema. In fact, this could be very handy if you ever needed to create a quick backup of the table before any crucial data manipulations. So we’ve now made it work!
Quick group creation
Now, drag-and-drop also works for creating groups in the database explorer.
To create a new group, just drag one data source onto the other.
To place the data source into an existing group, drag-and-drop it there.
Live connections
Starting with version 2019.2, the small green light indicates if there is a live connection to the data source.
Force Refresh
A new action is available for the data source or schema, called Force Refresh. It clears the data source information that DataGrip caches, and refreshes it from scratch.

---

Filtering by a data source in search and navigation

When you are locating an object in the GoTo popup, sometimes many similar objects are present in the list. It frequently happens when you have many mirrors such as production, staging, test, and so on.
In DataGrip 2019.2, you can choose where to search: in a specific data source or in a group of them.
The same works for Find In Path, which is extremely useful when searching for source code inside of other objects’ DDLs.

---

Coding assistance

Objects from system catalogs
In nearly every database there is a system catalog – the place where a relational database management system stores schema metadata, such as information about tables and columns, built-in functions, etc.
Objects from these catalogs are needed to provide coding assistance. It’s nice to have them in code completion, and code that uses them should not be red.
Before, the only way to have system catalogs in coding assistance was to add them to the database explorer. DataGrip actually retrieved information about them from the database (always the same, by the way!), which took time. Also, they were visible in the database explorer, which is not always necessary.
This kind of schemas have a lightning icon in the schema chooser. Now, if you don’t check them, DataGrip will not introspect and show them, but will use the information about their objects in coding assistance. To make this possible, DataGrip uses its internal data about system catalogs for each database.
Intention-actions and quick-fixes
First, we’ve integrated a quick-fix into the inspection tooltip. If DataGrip knows how to fix the problem, you will know about it by just hovering the mouse over the warning. To fix the problem, just click the link at the bottom left corner of the tooltip, or press Alt+Shift+Enter.
Alt+Enter still works for getting the list of all the possible quick-fixes.
We’ve also introduced several new inspections.

---

SQL editor

New option to control the behavior of Move Caret to Next Word
The default behavior of the Move Caret to Next Word action has changed: DataGrip will move the caret to the end of the current word.
To change the behavior of the caret movement actions, go to Preferences/Settings | Editor | General.
People usually perform this action by pressing Ctrl+Arrows on Windows and Linux and Opt+Arrows on Mac. It has a different default behavior on different operating systems. In Datagrip, we’ve changed the Windows-like behavior to the Mac-like one.

---

Other

- DataGrip 2019.2 runs under JetBrains Runtime 11, the uncertified fork of OpenJDK 11, by default.
- If you want to see comments for tables in the tree view, go to View | Appearance and toggle the Descriptions in Tree Views option.
- [Cassandra] You can now edit these types of columns: set, list, map, tuple, udt, inet, uuid, and timeuuid.
- New combined items are now included in code completion: IS NULL and IS NOT NULL.
- The option Jump outside closing bracket/quote with Tab is enabled by default.
- The option Surround a selection with a quote or brace is enabled by default.
- Introduce alias has been added to the refactoring menu.
- DataGrip works with PostgreSQL 12: DBE-8384.
- There was some inconsistency when working in read-only mode: if you wanted to run an update query from the read-only mode, the IDE turned off only the IDE-level mode, but not the JDBC one: DBE-8145. Now though, we turn off both so you can run the query if you really need to.