DataGrip 2019.3.2: Virtual foreign keys and more!
Hello! This is the second bugfix update for DataGrip 2019.3. Here’s what it has inside:
Virtual foreign keys
We’ve introduced the concept of virtual foreign keys. You can use this concept in the event that you need to use a relationship that exists but is not located in your database.!
Doing so will help you:
– Have the proper completion when writing JOIN clauses.
– See the relations in diagrams.
By default, DataGrip tries to guess if you have relations between columns whose names contain id. It looks like this:
These relations are also displayed in the diagram. If you don’t want them to be there, just click on the corresponding icon on the toolbar.
You can also create a custom rule under Settings | Preferences for guessing whether there are relations: :
As you can see, DataGrip 2019.3 only includes one pre-built pattern, which was particularly designed to handle the examples above. You can add your own with the help of the regular expressions. To learn more about this feature, you can visit our help page.
When you write code, any relation from the JOIN clause can be stored as a virtual foreign key. Press Alt+Enter and choose Store table relation.
DataGrip will ask you to identify a file where these virtual relations will be stored.
The resulting XML file will look like this, and you can then edit it directly:
Stored procedure runner for MySQL
Finally, after adding the option to execute stored procedures in PostgreSQL, MS SQL and Oracle, we’ve now made it possible to do so in MySQL.
DBE-9829 Aliases are no longer used when completing table names in DDL.
DBE-9800 Only trigger functions are offered in the corresponding completion list.
DBE-9803 The wildcard is now resolved inside row constructors.
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 …
Today, we’re releasing the second minor update for DataGrip 2023.1. Here are the most notable changes and bug fixes in v2023.1.2: DBE-16982 A memory leak that occurred when exporting data to a file has been fixed. DBE-17820 Add/Clone/Delete Column menu items no longer disappear when editing a…