DataGrip 2020.3

JSとSQL間の翻訳機能を追加しSQLでMongoDBのデータベースを問い合わせ可能
11月 26, 2020 - 16:45
新バージョン

特徴

  • Added JS-SQL translator so that you can now use SQL to query MongoDB databases.
    • Only SELECT queries work, and the working сlauses are JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET.
  • Connectivity
    • Added Couchbase support. It’s important to mention that DataGrip supports the Couchbase Query service, not the Couchbase Analytics service.
    • Added support for Microsoft Azure AD authentication.
      • You can now specify the working directory for the process that handles working with data sources. Also, all relative paths will be resolved in this directory, for instance in driver properties.
  • Data editor
    • Improved the cell values editor.
    • It can now display the formatted value even if the value is stored as one line. Moreover, you can edit the value in the formatted view and update it with the original formatting. This works with single-line XMLs and JSONs.
    • If the width of the screen is crucial to your flow, you can move the cell value editor out of the way to the bottom of the data editor.
    • This panel can now also display images.
    • Added the ability to open tables and views in the transposed view by default.
    • Added the ability to shrink selection action in tables.
  • Import/Export
    • Added two new extractors: One-row and SQL-Insert-Multirow
      • One-Row will help you copy a column to a comma-separated string. This can be extremely useful for pasting a set of values in an IN clause.
      • SQL-Insert-Multirow will generate a single INSERT statement with the multiple new rows that will be inserted.
    • Added a new option in CSV format configuration: never quote values.
  • Introspection
    • Added the ability to collect introspection diagnostic information.
    • DataGrip now knows about object grants and displays them in an object’s DDL.
    • If you’ve changed the DDL of some objects but haven’t submitted them yet, the objects waiting to be submitted are highlighted in the database tree. Previously you could only see them in the Database Changes tool window.
    • Added new properties for tables in PostgreSQL - Now generates DDLs with TABLESPACE and INDEX ACCESS METHOD.
    • Added new objects in Greenplum - DataGrip now shows more objects in the database tree. The new objects are collation, materialized view, foreign table, foreign data wrapper, foreign server, and user mapping.
    • Now displays correct overloaded procedures in Oracle.
  • Coding assistance
    • Added the ability to use the SQL formatter when working with unsupported databases.
    • Added new Rename options - Inline renaming will now offer you the option to work with comments, strings, or text occurrences.
    • Alt+Enter on Microsoft Windows and Linux and Opt+Enter on Apple Mac will offer you options to fix typos without needing to open a nested menu.
    • Added a new inspection for Oracle - If there is a call conflict when using an overloaded function, DataGrip will warn you about it.
    • Added new options for casing in the formatter - Now you can define the separate casing settings for built-in types, custom types (instead of just types) and functions.
  • Running queries
    • Added new usability features to help you run scripts:
      • Schema switching - DataGrip will warn you if a script contains schema switching.
      • Displaying the default schema - If you choose just a data source as a target, DataGrip will display the particular schema in which the script will be run.
      • History targets - It is now possible to choose a target from the history: just click the small clock button.
      • Console output in a separate tab - Introduced the Open new services tab for sessions option in Settings/Preferences/Database/General. When it's turned on, a separate tab is created for each new database session, so you won't see the Services tree. Just the grid or the output.
      • Tab names in Microsoft SQL Server - Added the ability to name result tabs.
      • Hints for indexes in ‘Explain plan’ SQL Server - In the Explain plan tool window, DataGrip will now offer to create indexes for you if the database thinks it could help with the performance of the query.
  • DDL editing
    • Warning for outdated table structures - If you open a view, a routine, or a function for editing, but that object has been changed in the database and you're editing the outdated version, DataGrip will warn you about it.
    • Warning if the object was deleted - If an object was deleted completely, you will get a dedicated warning about it.
      • Imagine that you opened the DDL of the routine inventory_in_stock, made some changes, but at that exact moment somebody dropped it. DataGrip offers three options:
        • Revert local changes: use this when you don't want to edit the procedure anymore and you're ok with the fact that it was deleted. The DDL editor will be closed.
        • Keep local changes: use this when you want to continue editing the procedure, though in fact, when you press Submit, you will recreate it. The changes are no longer highlighted, because a server version is no longer available.
        • Restore in the database: use this when you want DataGrip to restore the procedure based on the cached version from the moment of the last refresh. Your changes will continue to be highlighted, because the server version is now available again.
    • Migration actions are available everywhere - The Submit, Rollback, and Show Changes actions are now available everywhere in the context of the object. They are also in the object’s context menu.
  • General
    • Drag and drop tabs - You can now drag and drop tabs to split the editor either horizontally or vertically. If you would like to pin your results to the tab in split mode, use In-Editor Results for each of them.
    • The Welcome screen - When you open DataGrip 2020.3 it will still take you straight to the last opened (or the default) project. But when you close all of your projects, a Welcome screen will appear. Here you can access all of your projects, manage plugins, and customize the IDE.
    • Per-Project plugins - Settings/Plugins now has the option to only enable or disable a plugin for the current project. A plugin will be loaded automatically when the first project requiring that plugin is opened, and it will be unloaded automatically when the last such project is closed.
    • Syncing current theme with OS settings - If the user selects Sync with OS in Settings/Preferences/Appearance & Behavior/Appearance/Theme, the IDE will automatically switch to the light or dark theme when the OS UI makes the same change.
    • Apple macOS shortcuts as words - If you are struggling to read the macOS shortcuts, try toggling the ide.macos.disable.native.shortcut.symbols key in the registry.
    • Preview tab - You can now open a file in a preview tab with a single click.
    • Simple calculator - You can now enter simple mathematical formulas in the search bar of the Search Everywhere dialog and you will see the calculated result right away.
    • File associations - You can now make DataGrip the default application for opening specified types of files.
    • Expand all - Collapse All is now accompanied by the Expand All button in the Database and Files tool windows.
SQL for MongoDB

DataGrip(英語版)

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

DataGrip(英語版)は、次の製品にも含まれています。

ご質問がありますか?

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