DataGrip2020.1.5

Name: DataGrip
Price: 89.00 $
Rating: 5 (2 reviews)

26 June 2020

IDE for professional SQL developers.

Overview

DataGrip is a new database IDE that is tailored to suit specific needs of professional SQL developers.

Intelligent query console: allows you to execute queries in different modes and provides local history that keeps track of all your activity and protects you from losing your work.
Efficient schema navigation: lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code.
Explain plan: gives you an extended insight into how your queries work and into database engine behavior so you can make your queries more efficient.
Smart code completion: DataGrip provides context-sensitive code completion, helping you to write SQL code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing.
On-the-fly analysis and quick-fixes: DataGrip detects probable bugs in your code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, using keywords as identifiers and always offers the way to fix problems.

Note: the price shown in the listing is that of a 1-year individual customer subscription. To view more pricing options, go here.

Version 2020.1.5:

Forced execution in read-only mode now runs the correct query.
Schemas comparator respects column order.
[PostgreSQL]: DataGrip no longer throws a time zone error for versions of PostgreSQL before 10.
[Snowflake]: The Modify Table dialog generates valid code.

A new quick-fix is available: Refresh schema. If your colleague adds a new object after you have already refreshed your database, this fix will make sure your query is properly highlighted.
We have also renamed the migration buttons in the schema comparator to make it clearer what they actually do.
If you create a DDL data source, the folder with the sources will automatically be attached to the project.
If you try to change the DDL of the target table during the data import process, DataGrip will double-check this with you with an alert box to confirm that you want to perform this action.
If an Oracle database wants you to change an expired password, you can do so from the DataGrip UI. This works for versions from Oracle 12.2 if you use the standard JDBC driver. If you use the OCI driver, it works for the older versions as well.