DataGrip 2019.2 EAP 3

Maksim Sobolevskiy

Hello! Please welcome the newest build of our DataGrip 2019.2 EAP.

Objects from system catalogs in coding assistance

Nearly in 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. So, 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, but that’s not always necessary.

This kind of schemas have the 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 have this possible, DataGrip uses its internal data about system catalogs for each database.

MinCatalogs

Some examples of system catalogs for several databases:

PostgreSQL: pg_catalog, information_schema
SQL Server: INFORMATION_SCHEMA
Oracle: SYS, SYSTEM
MySQL: information_schema
DB2: SYSCAT, SYSFUN, SYSIBM, SYSIBMADM, SYSPROC, SYSPUBLIC, SYSSTAT, SYSTOOLS

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.

ForceRefresh

Easily change the results page size

Now, to define how many lines you want to be retrieved from the database, you can do it from the result-set’s toolbar.

PageSize

Name your results tabs

Another super-cool improvement for results: tab naming! Just use the comment before the query.

PrefixNames

If you don’t want any comment to become a tab name, use the Prefix in settings: only words coming after that prefix word will be used as titles.

PrefixSettings

Now you can see which particular statements DataGrip will run to perform a data search.

FTSPreview

Fold big numbers

If you want to improve the readability of big numbers, fold them with the shortcut: Ctrl/Cmd+Minus.

Folding

That’s all for this new EAP! Stay tuned for the next EAP release coming your way. 2019.2 is going to be cool!

The DataGrip Team

Comments below can no longer be edited.

9 Responses to DataGrip 2019.2 EAP 3

  1. Artem says:

    July 11, 2019

    Is it available in the Toolbox?

    • Maksim Sobolevskiy says:

      July 11, 2019

      Yes

  2. DGUser says:

    July 11, 2019

    Please, add some way to hide system schemas (at least postgres has a ton of toast/temp schemas like on your screenshot). It is really annoying to filter them on heavy loaded instances.

    • Maksim Sobolevskiy says:

      July 18, 2019

      If you don’t check them in that pop-up they will not appear in the tree

  3. Fritz says:

    July 15, 2019

    Hi,
    thanks for the great product.
    I still have one issue now for months which I couldn’t tackle:
    On Mac OS, passwords still cannot be saved.
    When I save them and select “forever”, after next restart I get an error message saying, that the password was not provided.
    Is this on your task list to be fixed?
    This is quite annoying.

    Best regards
    Fritz

    • Maksim Sobolevskiy says:

      July 18, 2019

      Hi! There is no task, please, create it: youtrack.jetbrains.com/issues/DBE

    • Maksim Sobolevskiy says:

      July 29, 2019

      Thanks for the report! We’ll fix that. Please, also comment here: https://youtrack.jetbrains.com/issue/IDEA-216926

  4. Alan says:

    July 16, 2019

    Saw a large performance degradation on this EAP in terms of UI responsiveness. I was going to open an issue and document it, but since it was getting in the way of my work I just rolled back to the previous version. (Disabled most plugins and it made no difference.)