The DataGrip Blog

The Cross-Platform IDE for Databases & SQL

News

DataGrip 2018.1.3

Maksim Sobolevskiy

Hello! This is another minor update for 2018.1. Here is the list of important bug-fixes:

Oracle
DBE-3195 — Auto-completion for object types
DBE-5340 — Compiling PL/SQL code works OK
Support for:
DBE-2581 — Conditional compilation flags
DBE-6027 — SET statements with multiple clauses
DBE-6196 — INSERT ALL
DBE-6378 — JSON keyword

PostgreSQL
DBE-6301 — The bug with creating foreign keys between tables is fixed
DBE-6391 — Fields are resolved in LOOP cycle

Redshift
DBE-6336 — MAXFILESIZE support for UNLOAD

Sql Server
DBE-6325, DBE-6370 — Columns for OUTPUT are resolved
DBE-6354 — Support for ORDER BY in subqueries

H2
DBE-6367 — CTE support
DBE-6368 — DROP CASCADE support

DataGrip team

DataGrip 2018.1.2 Copy and Share Data Sources in IntelliJ-based IDEs

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

DataGrip 2022.3 EAP 3

DataGrip 2022.3 EAP 2: Redis Support