The DataGrip Blog

The Cross-Platform IDE for Databases & SQL

News

DataGrip 2017.3.4

Maksim Sobolevskiy

Here is the first bug-fix update this year. Many issues have been fixed, the most important of which are:

Collations are now placed after schemas in the database tree. If you want to hide them, put collation:-.* into Data source properties → Options tab → Object filter.

DBE-5703: А correct DDL statement is now generated when a PostgreSQL function with defaults is dropped.
DBE-5608: Amazon Redshift data source synchronization works now.
DBE-5404: The editor now recognizes the WITH NO SCHEMA BINDING syntax in Redshift.
DBE-2465: FETCH ALL IN <cursor name> doesn’t return errors anymore.
DBE-5274: FOR EACH ROW WHEN in triggers shows the correct clause.
DBE-4983: SQL generator doesn’t add the ‘n’ character in new lines in Oracle anymore.

Fixed freezes:
DBE-2536: While introspecting schemas with many tables.
DBE-5532: After updating a function.

DataGrip team

DataGrip 2017.3.3 Generate simple classes from database objects in DataGrip

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

The DataGrip Blog

DataGrip 2017.3.4

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 Release Candidate

DataGrip 2022.3 EAP 3

DataGrip 2022.3 EAP 2: Redis Support