Shulou(Shulou.com)05/31 Report--

This article mainly introduces the use of DataGrip, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

DataGrip is a database management software developed by JetBrains. DataGrip supports almost all mainstream relational database products, such as DB2, Derby, H2, MySQL, Oracle, PostgreSQL, SQL Server, Sqllite and Sybase, and provides an easy-to-use interface. Developers will hardly encounter any difficulties.

JetBrains DataGrip 2020 featur

Data editor

Column comments in a tooltip

Intelligent code

Completion DataGrip provides context-sensitive code completion to help you write SQL code faster. Finish identifying table structures, foreign keys, and even database objects created in the code you are editing.

Real-time analysis and quick repair

DataGrip detects possible errors in your code and recommends the best option to fix them dynamically. It immediately lets you know about unresolved objects, uses keywords as identifiers, and always provides a solution to the problem.

Log update

The complete SQL log first, you will now see each query that DataGrip runs in the console output. Whether it's something your SQL or DataGrip needs to run internally, check the output tab to see what's going on.

Second, all queries from IDE are now recorded in a text file. To open this file, go to help | display the SQL log.

New SQL formatter

Thank you for sharing your thoughts on SQL style with us! We hope that DataGrip can now accommodate more different code styles. The new SQL formatter is a feature we strongly need feedback on, so please give it a try and let us know if your specific case is not covered. We are still trying to add new terms.

As you may already know, you can create a custom code style scheme. Now, any one of them can be used exclusively for each data source. To do this, go to the options tab of the data source properties.

Run a stored procedure

Select execute from the process's context menu. The SQL code is generated. Enter a value for the desired parameter, and then click OK. As you can see, we retrieve the output of this mysql procedure because we have SQL code to get the result set from the JDBC driver.

Query plan (artifact that optimizes performance)

Query plan diagrams chart-based views are now available for query plans. To view it, click the Show Visualization button on the toolbar after invoking the description plan.

SQL editor

When editing a large process in a package, context information is sometimes useful to refresh memory in its context, that is, the specific process or package that is now being edited. To do this, press Shift+Ctrl+Q to view the context information.

Skip to closing parentheses / quotes starting with this version, you can navigate or close quotation marks outside the closing parentheses by pressing the Tab key. Note that this is only valid the first time you enter a parameter or value. To customize this behavior of Tab, go to preferences | Edit | General | Smart key and choose to jump outside the closing parentheses / use the Tab key reference.

Navigation

Before you assign a shortcut from a find operation, if you use the default keyboard mapping, you cannot specify a shortcut from the find operation. We have fixed this bug and now it applies to any keyboard mapping and any layout. A good reason to remind you that this is possible!

Navigation allows you to jump to any table, view, or procedure by name, or directly from usage in SQL code, to any table, view, or procedure.

In general, DataGrip is a comprehensive database IDE for administrators and SQL developers. It has practical functions and supports mainstream relational database products on the Internet, such as DB2, Derby, H2, MySQL, Oracle, PostgreSQL, SQL Server, Sqllite and Sybase. It can not only perform common functions such as sql, creating tables, creating indexes and exporting data, but also highlight keywords, and the prompts for fields are also very intelligent.

Thank you for reading this article carefully. I hope the article "what's the use of DataGrip" shared by the editor will be helpful to everyone? at the same time, I also hope that you will support and pay attention to the industry information channel, and more related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.