JetBrains DataGrip 2018.1.3 macOS

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

Features:

• 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.

OS version:OS X 10.8 or later

Web Site: https://www.jetbrains.com/datagrip/

What’s New in JetBrains DataGrip 2018.1.3

• DBE-3195 – Auto-completion for object types
• DBE-5340 – Compiling PL/SQL code works OKSupport for:
• DBE-2581 – Conditional compilation flags
• DBE-6027 – SET statements with multiple clauses
• DBE-6196 – INSERT ALL
• DBE-6378 – JSON keywordPostgreSQL:
• DBE-6301 – The bug with creating foreign keys between tables is fixed
• DBE-6391 – Fields are resolved in LOOP cycleRedshift:
• DBE-6336 – MAXFILESIZE support for UNLOADSql Server:
• DBE-6325, DBE-6370 – Columns for OUTPUT are resolved
• DBE-6354 – Support for ORDER BY in subqueriesH2:
• DBE-6367 – CTE support
• DBE-6368 – DROP CASCADE support

Descriptions for JetBrains DataGrip 2017.3.3

Name: DataGrip
Version: 2017.3.3
Released: Dec 20th, 2017
Developer: JetBrains
Mac Platform: Intel
OS Version: OS X 10.8 or later

Includes: Keygen

Web Site: http://www.jetbrains.com/

Overview

Manage multiple types of databases with this intuitive IDE that makes it easy to write SQL code and offers a wide range of useful features

DataGrip is a versatile application that caters to the needs of database administrators and SQL developers, supports a broad range of data sources and offers numerous helpful tools that can speed up your workflow.

Powerful tool that supports multiple types of databases and provides automatic code completion

DataGrip is a multi-engine database environment that enables you to connect to various data sources, such as MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Sybase, SQLite and DB2. Essentially, if the database management system uses JDBC, it is supported by DataGrip.

As you would expect from a database IDE, DataGrip offers context-sensitive code completion, which can significantly reduce the time it takes to write SQL code. This function takes multiple factors into account, such as table structure and foreign keys.

Of course, it is impossible to avoid mistakes altogether, but this utility can help you out by detecting errors while you are writing code and offering suggestions for dealing with them.

Easy-to-use query console and smart variable refactoring

Renaming a variable in your database can cause a lot of headaches, as any references made to it become invalid. However, DataGrip enables you to quickly refactor them and update the variable’s usage in the entire file.

DataGrip also allows you to execute queries with very little effort and keep track of your work with the help of a handy history log.

Sleek, modern interface and fully customizable keyboard shortcuts

DataGrip offers a well-designed interface that can be personalized in numerous ways. You can display or hide various toolbars or menus, and you have complete control over their layout.

Additionally, the application lets you choose from multiple color schemes, and you can enable the Distraction Free mode when all you need to do is write code.

Most of the app’s functions can be controlled with hotkeys, and they are fully customizable. You can either select one of the existing profiles or create an entirely new one.

Overall, DataGrip is a comprehensive database IDE for administrators and SQL developers. It is packed with useful features, offers a well-designed, modern interface and is very intuitive.

What’s new in DataGrip 2017.3.3 Build 173.4127.18

December 20th, 2017

• This update brings an important fix of “Out of memory” problem.