DataGrip2020.3.1

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

25 December 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.3.1:

Starting from this version we provide builds for Apple Silicon M1 processors. They can be found on the download page for macOS.

We’ve come up with a counterpart for the existing action ‘Extract CTE from the subquery’ - ‘Inline CTE’. Use it to create a subquery instead of using common table expressions.

With version 1.9 of the MongoDB JDBC driver and DataGrip 2020.3.1, all SSL modes are now available.

DBE-9945: [PostgreSQL, Greenplum] WITH block is included in the DDL.
DBE-2489: [SQL Server] Allow unqualified calls of stored procedures from sys schema.
DBE-3893: [SQLite] JSON1 functions are supported.
DBE-12193: [SQLite] Virtual columns are highlighted properly.
DBE-10007: [Oracle] Simplified table functions are supported.
DBE-12051: [Oracle] The "Refresh could not take such arguments" warning isn’t falsely triggered anymore.