Datagrip logo

The DataGrip Blog

The Cross-Platform IDE for Databases & SQL
Download
Early Access Program Features News

DataGrip 2019.2 EAP 3

Maksim Sobolevskiy
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

SQL preview in full-text search

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

2019.2 EAP
DataGrip 2019.2 EAP 2DataGrip 2019.2 RC

Discover more

DataGrip 2022.3: Redis Support, Quick Filter In Database Explorer, Pattern-Based Schema Filtering, Formats for Datetime Fields, and More!

DataGrip 2022.3 is here! This is the third major update of 2022, and it’s packed with various enhancements. Let’s take a look at what it has to offer! For a detailed description of this update, please visit our What’s new page. General Redis SupportNew UI available via settingsNew Settings Sync solutionVirtual viewsNavigation in diagrams Database explorer Quick filterPattern-based schema filteringColors for global data sourcesDrag-and-drop for script files Data editor Working with code Intention action previewSingle line copy-pasteNew layout for the SQL sch

Alisa Lukonina Alisa Lukonina

DataGrip 2022.3 Release Candidate

This is the release candidate for 2022.3. Check out these publications for a reminder of what’s new in this version: 2022.3 EAP 12022.3 EAP 2: Redis support2022.3 EAP 3 Try it out and share your feedback with us! 

Alisa Lukonina Alisa Lukonina

DataGrip 2022.3 EAP 3

Hello! Here’s a brief overview of what we've released in the latest update to DataGrip 2022.3 EAP. UI for virtual foreign keys The ability to create virtual foreign keys was introduced a while ago and the main way to create them was by using the intention action Store Relation at the JOIN clause in your query. This was a little bit tricky to find and the whole functionality lacked an intuitive way to use it. Here’s an overview of the implemented changes:Virtual foreign keys are visible in the database explorer: You can create and drop them here, in the database explorer, and also

Maksim Sobolevskiy Maksim Sobolevskiy

DataGrip 2022.3 EAP 2: Redis Support

Summary In DataGrip 2022.3 EAP 2, we’ve implemented a preliminary iteration of long-awaited support for Redis. Here is the list of what is now supported: Connectivity: Redis Single Instance.Introspection: Introspection of databases and keys, including the ability to set a default key filter for the introspector.Database Explorer: Separate folders for keys of different types for Redis v6.0+, and one folder with all keys for older versions.Query Execution: The JDBC driver supports the execution of the majority of queries.Coding assistance: Code highlighting, keyword completion, and resolut

Maksim Sobolevskiy Maksim Sobolevskiy