DataGrip for Mac is a database management software developed by JetBrains. DataGrip supports almost all major relational database products. DB2, Derby, H2, MySQL, Oracle, PostgreSQL, SQL Server, Sqllite, Sybase, etc. IntelliJ IDEA Ultimate, PyCharm Professional Database plugin used in PhpStorm, RubyMine, GoLand and Rider.

The original download link: https://mac.orsoon.com/Mac/159624.html

DataGrip 2020 New features for MAC

Data editor

SQL Logging Now, when updating data, you can see the specific queries that the DataGrip is running. We have nothing to hide!

Two, general enhancement

Mode switching Mode Now you can tell the DataGrip how to switch modes. The following Settings are available: – Automatic: When defining the context, DataGrip can switch modes during internal operation. – Manual: The DataGrip mode cannot be switched during internal operation. However, you can manually switch them through the switcher in the upper right corner. – Disabled: No more wireless switches are required if you use PG_bouncer!

Rename Everything Starting with this release, we challenged ourselves to be able to rename all the objects we supported. Sequences in Oracle, events in MySQL, triggers in PostgreSQL, and many other objects can now be renamed Shift+F6 by pressing down. This applies to database trees and SQL scripts. Remember that the use of objects in other scripts will also be renamed.

Running the script Now, when you run the file against the data source, your selection is remembered for further running.

Quick Document for file We added quick document for file: press F1. For example, it’s much easier to know the file size now. But that’s not all!

Navigation we added an option called Use DDL Editor first data Editor. This option affects: – Navigate to table/View Cmd+O. – Navigate to the column Shift+Cmd+Alt+N. – Double-click the table/view or column in the database tree view. The reference that navigates to the DDL editor is now called the Prefer database view rather than the DDL editor. As you probably know, it defines what you will do when you Click “Navigate to declaration (Cmd+B or Ctrl+Click)” from SQL.

We combined two navigation operations: Go to course and go to table. Shortcut: Cmd+O – In DataGrip, you can now navigate to classes if you use any of the other supported languages. – In other JetBrains ides, you can finally see database objects such as tables, stored procedures, etc. Remember, there is a language filter.

3. Database view

We have added MariaDB to the list of supported databases.

DataGrip now supports Exasol for external modes in redshift and virtual architecture.

MySQL in the event is displayed in the database tree. Source code generation is also available.

The data source color affects the console files in the files pane.

DataGrip now supports partitioned tables in PostgreSQL 10.

4. SQL editing

DataGrip now lets you navigate to one or the next identifier that occurs by using two shortcuts, Alt + Wheel Down and Alt + Wheel Up. Alternatively, type Highlight Element Usage to find the action.

Completion of file references now applies to Oracle and Exasol.

Another new action in the DataGrip is to move elements to the left or right. This applies to different kinds of lists, including arguments inside functions, field and column lists in INSERT statements. Note that it does not corrupt the comma while working with a list of columns, as moving the line does.

Common table expressions are supported in MySQL.

Copy the entire line now and act on the project at the end of the file as well. If you don’t know what this does, it copies all selected lines and prefixes each line with a newline character. In many cases, it is more convenient than using Duplicate (Cmd+D).

The IDE now highlights areas of folded code that contain errors or warnings and colors blocks based on their validation status. Folded code is also highlighted if it contains matching search results.

Other improvements

The SQLite command used to break the highlight. No longer.

In the Replacement Path window, the IDE now allows you to preview regular expression substitutions.

The REST client plug-in is now available.

The code formatter does not change keyword case by default.