DataGrip 2017.2

Microsoft AzureおよびAmazon Redshiftに対応
8月 4, 2017
新バージョン

機能

  • New DBMS support Microsoft Azure and Amazon Redshift - Microsoft Azure is similar to SQL Server, so DataGrip adds a dedicated driver, UI for adding the data source and some enhancements in the introspection. For Amazon Redshift the introspection is now incremental. This means that only modified objects will be refreshed in a database tree after any operation instead of all objects. Also, DataGrip now supports specific cases in SQL grammar which are different from PostgreSQL. For example, UNLOAD statement is not only highlighted correctly, but has an SQL-injection inside.
  • Several databases in PostgreSQL - Data sources with several databases are also supported for Amazon Redshift, Microsoft Azure, and any unsupported databases whose drivers report several databases.
  • Transaction Control - This feature replaced the Auto-commit option. First, define what kind of transaction control you want to use when working with a particular data source. This option is available in data source properties. In the Auto mode you don’t need to commit any transactions executing the commit statement, while in the Manual mode, you, obviously need to do this. This also can be defined for each query console along with the isolation level. The data editor in the Manual mode also has Commit and Rollback buttons on toolbar. All actions are also available in the context menu.
  • Evaluate expression - This will help you see data without writing a query to the console. In other IntelliJ-based IDEs, Ctrl+Alt+F8 on an object gives you quick evaluation. In DataGrip, invoke it on a table in a query to see the data of that table. Ctrl+Alt+F8 on a column name will show the values of that column in the expected result-set. If you invoke the same quick evaluate on the keyword of a query (or subquery), the pop-up will show you the result. Note that Alt+Click also works for this. Press Alt+F8 to open an Evaluate pop-up, where any query can be run. If invoked on a table, it will show the data.
  • Table DDL - The Data and DDL tabs have been divided when viewing a table. Actually, there are no more tabs. Now, when you open a table with a double-click, you just see data. Where is the DDL? It can be opened by Edit Source on the toolbar or by Ctrl+B.
  • Integration with restore tools - Now they can be accessed from the context menu. If there’s only one tool available, this option will look like ‘Restore with pg_restore’, etc.
  • Executing queries
    • Attach console - There is a new action for any file called Attach console. You can find via Ctrl+Shift+A or by opening the context menu for a file. After performing this action, this file can be run against the console. Switching consoles will be useful if you want to run the same script in several data sources.
    • Notifications - A notification is now displayed when a large query is finished. To disable it, in Settings look for the “Database queries that took much time” notification. It appears if it took more than 20 seconds to execute a statement.
    • Autoscroll from/to result-set - Many of you have asked for result-sets to be switched along with the corresponding consoles. Done! The same works in the opposite direction. These behaviors are on by default, look for the “Autoscroll ..” toggles in the gear-icon menu of the Database Console tool window.
    • Subquieries - When you execute a query with subqueries, the outer statement is selected in the drop-down by default. Well, nested statements often just cannot be executed at all.
    • Read-only connections - Schema switcher works in MySQL even with a read-only connection.
  • Coding assistance
    • Completion now works for columns in table-valued functions.
    • NEW and OLD references are resolved in PostgreSQL triggers.
    • Added support for MERGE statements for all databases where they are available.
    • Sequences are resolved in scripts as well.
  • Other Improvements
    • Database objects can be added to Bookmarks.
    • We added per-monitor DPI support for Windows. Font settings are automatically adjusted based on the display resolution.
    • Lines with two identical results are merged in Find in Path.
    • Support for non-int-literal expressions in TABLESAMPLE and ALTER FOREIGN TABLE in PostgreSQL.
    • Support for ‘json_table’ function in Oracle.
    • You can now pause file indexing when you need to free the CPU for other tasks, and then resume it when appropriate.
DataGrip 2017.2
Support for Microsoft Azure and Amazon Redshift.

DataGrip

プロのSQL開発者とデータベース管理者向けに作られたデータベースIDE

見積もりの依頼 購入

DataGripは、次の製品にも含まれています。

ご質問がありますか？

今すぐ JetBrains ライセンススペシャリストとライブ チャット。