DataGrip 2021.2 EAP 3
Hello! The third EAP build for 2021.2 is available! Try it out and share your feedback with us.
[MongoDB] Add/delete column
Now there is the ability to add columns to MongoDB collections. This action lets you add a new field to any document of a collection.
Delete column will delete data not only on the page that is being displayed, but also throughout the whole collection.
We’ve made the behavior of the navigation bar more straightforward: the Enter key always expands the node.
What the Enter key did before:
- Opened data for tables
- Opened consoles for data sources
If you want to navigate from the object in the navigation bar rather than opening its node, you can use these navigation shortcuts:
Open DDL: Ctrl/Cmd+B
Open data: F4
Select in the database tree: Alt/Opt+Shift+B
Separate nodes for triggers, keys, and indices
The new database tree option called Show Constraints and Triggers in the schema gives the separate nodes for triggers, keys, and indices.
Why is this useful?
- To find an object inside one schema with the help of a quick search.
- To see the columns just under the table node. To do this, the Show Empty Groups option must be turned off.
Better layout for diagrams
We have improved the algorithm that draws diagrams, so the names of the objects don’t overlap with relation lines anymore.
CockroachDB native introspection
CockroachDB will be fully supported in this release – DataGrip will no longer rely on JDBC-based introspection, but use the native one.
This is much faster than JDBC-based introspection. Also, role, deftype, and check constraint weren’t introspected at all in the previous version. The full list of objects that are now introspected includes database, role, privilege, schema, sequence, deftype, table, view, mat view, index, column, and constraints. It’s a known issue that partitions are not introspected yet.
Another resolved issue is that DDL generation no longer includes the fake column for tables with primary keys.
create table tab ( col int8, rowid int8 default unique_rowid() not null constraint "primary" primary key );
create table tab ( col bigint ); alter table tab owner to root;
Show scratch files action
A new Show Scratch Files action (found via Find Action: Ctrl/Cmd+Shift+A) shows a list of scratches with snippets in a popup. It has the same UI as the Recent Locations popup with speed-search and deletion.
Subscribe to Blog updates
Thanks, we've got you!
DataGrip 2023.3 EAP 2 is Out!
Hello, DataGrip community! The second Early Access Program version for DataGrip 2023.3 is here. If you want to try the new features before the official release, this is for you! Introspection scheduler It's now possible to set an introspection interval for each data source. Materialized…
DataGrip 2023.3 EAP is Open
Hello! We’re starting our 2023.3 Early Access Program (EAP) and, as usual, we invite you to try the latest features and improvements we’re adding to DataGrip ahead of the official release. Let’s take a look at what’s inside the first EAP build. DataGrip takes a long time to introspec…
DataGrip 2023.2: New UI with toolbar icons in the header, AI Assistant, time zones in the data editor, support for Redis Cluster
DataGrip 2023.2 is out!Here’s a sneak peek at what it has to offer. For a detailed description of this update, please visit our What’s New page. User Interface New UI: The toolbar icons have been moved to the header Improved main toolbar customization Light theme with light …
DataGrip 2023.2 EAP 2: Redis Cluster, New Schema Migration Dialog and More
Hello, DataGrip community! The second Early Access Program version for DataGrip 2023.2 is here. If you want to try the new features before the official release, this post is for you! Support for Redis Clusters Now you can connect to Redis Clusters and have the same feature set as with standalo…