The DataGrip Blog

The Cross-Platform IDE for Databases & SQL

News Releases

DataGrip 2021.2: Creating DDL data sources from real ones, Better diagrams, Search in Local History

Maksim Sobolevskiy

Read this post in other languages:
Русский

Table of Contents

DataGrip 2021.2 is here! This is the second major update of 2021, 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.

DDL data source

Generation from a real data source
Creating objects

Diagrams

Table comments are now visible
Table colors are also displayed on the diagram
Ability to turn off edge merges

Code editor

Search in Local History
Local History for sources
Long tab names are back
Maximize Editor / Normalize Splits action

Code completion

Completion scope
[MongoDB] Completion of fields and operators
[SQL Server] Completion for cross-database synonyms
INSERT completion and computed columns

Code highlighting

[Redshift] Support for recursive CTE
[ClickHouse] Better CTE support

Database explorer

Separate folders for functions and procedures
Separate nodes for triggers, keys, and indices
Natural sort order for database objects

Introspection

[CockroachDB] Native introspection
[PostgreSQL] Virtual foreign keys for pg_catalog
[Oracle] Tablespaces
[SQL Server] Linked Servers

Data editor

Context live templates from the data editor
Additive sorting option
[MongoDB] Add/delete column
Add/rename columns in CSV files
Copy query to console
No more First row option in navigation by foreign keys
Qualification in navigation by foreign keys

Import/Export

Table link after import

Navigation

Behavior of the Enter key in the navigation bar
Signatures in the Go To popup

General

Localized UI
New location for projects
Back and forward buttons in Settings
Advanced Settings
Show scratch files action
Managing the Services tool window popups

Download DataGrip 2021.2

DataGrip team

Don’t Lose Your Work! Stay Safe With DataGrip DataGrip 2021.2.1

Discover 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

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!

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

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