DataGrip 2018.2

IDEからのすべてのクエリをテキストファイルに記録、ストアドプロシージャを実行可能
7月 31, 2018
新バージョン

機能

  • Full SQL log - See every query that DataGrip runs in the console output. Whether it’s your SQL or something DataGrip needs to run internally, check the Output tab to understand what’s going on.
  • SQL log file - All queries from the IDE are now logged in a text file.
  • New SQL formatter - You can create custom Code Style schemes and any of them can be used specifically for each data source.
  • Running stored procedures - This long-awaited feature has been implemented. Select Execute from the context menu of the procedure. The SQL code will be generated. Put in the values of the parameters you need and click OK.
  • Source code migrations - To update the source code of any objects, just double-click them and make the changes. The gutter (the vertical bar to the left of the text editor) will highlight the changes you’ve made. After you click Submit, the migration dialog will show the generated SQL code to update the source code.
  • Query plan diagram - A diagram-based view is now available for the query plan. To view it, click the Show Visualization button on the toolbar after you invoke Explain Plan.
  • Context info - When editing a huge procedure in a package, it is sometimes useful to refresh your memory on its context, i.e. what particular procedure or package is now being edited. To do this, press Alt+Q to see the context information.
  • Jump outside closing bracket/quote - Starting with this version, you can navigate outside the closing brackets, or closing quotes, by pressing Tab. Note this works only when inputting parameters or values for the first time.
  • Data Editor                    
    • Column comments in tooltips
    • Number of selected rows - Now DataGrip shows the number of rows selected in the data editor.
  • UI upgrades
    • Run SQL on a schema - Before, the only way to run the script was by executing it from the context menu of the corresponding SQL file. Now you can use a more intuitive way: choose the datasource or the database you need and select Run SQL script from the context menu.
    • Dark window headers - Now you can make the Darcula theme even darker. If you are on a macOS, to darken the title bars, just go to Preferences - Appearance & Behavior - Appearance and select Use dark window headers.
    • Touch bar support - Added support for the MacBook Touch Bar.

不具合の修正

  • MySQL comments are being formatted properly.
  • DDL for a table opens in a right place.
  • Deleting the criteria from the Filter field shows all rows in the data editor.
  • Backspace doesn't break quick search in Structure View.
  • Views with no schema binding in Redshift are shown in the database tree.
  • Record count in data editor works if sorting applied.
  • IDE opens empty files after restart.
Full SQL log

DataGrip

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

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

ご質問がありますか?

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