Datagrip logo

The DataGrip Blog

The Cross-Platform IDE for Databases & SQL
Download
Minor updates News

DataGrip 2020.1.5

Maksim Sobolevskiy
Maksim Sobolevskiy

Introducing DataGrip 2020.1.5! Check out what’s new inside!

Most important

The issue with SQL Server Authentication on Windows is fixed.

Other fixes

DBE-9876: Forced execution in read-only mode now runs the correct query.
DBE-10727: Schemas comparator respects column order.
DBE-10715: [PostgreSQL]: DataGrip no longer throws a time zone error for versions of PostgreSQL before 10.
DBE-10724: [Snowflake]: The Modify Table dialog generates valid code.

New features

A new quick-fix is available: Refresh schema. If your colleague adds a new object after you have already refreshed your database, this fix will make sure your query is properly highlighted.

Screenshot 2020-06-25 at 15.35.21

We have also renamed the migration buttons in the schema comparator to make it clearer what they actually do.

Screenshot 2020-06-25 at 15.35.26

If you create a DDL data source, the folder with the sources will automatically be attached to the project.

Screenshot 2020-06-25 at 15.35.29

If you try to change the DDL of the target table during the data import process, DataGrip will double-check this with you with an alert box to confirm that you want to perform this action.

Screenshot 2020-06-25 at 15.35.35

If an Oracle database wants you to change an expired password, you can do so from the DataGrip UI. This works for versions from Oracle 12.2 if you use the standard JDBC driver. If you use the OCI driver, it works for the older versions as well.

Screenshot 2020-06-25 at 15.35.39

2020.1 bug-fix update
DataGrip 2020.2 EAP 2DataGrip 2020.2 EAP 3

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