The DataGrip version is a database management software launched by JetBrains, which supports almost all mainstream relational database products, such as DB2, Derby, H2, MySQL, Oracle, PostgreSQL, SQL Server, SQLLITE, and SYBASE, etc., and provides easy easy to use. Interface, developers will not encounter any difficulties.
JetBrains DataGrip 2020 features
Data editor
Tool Tips in Collections
Smart code
Complete DataGrip provides a context-related code to complete, help you write SQL code faster. Complete the table structure, foreign key, or even database objects you are editing.
Instant analysis and rapid repair
DataGrip will detect errors in the code and suggest dynamically fix their best options. It will immediately let you understand the unresolved object, use the keyword as an identifier, and always provide a solution to the problem.
Log update
Complete SQL log first, now you will see each query running in the console output. Whether your SQL or DataGrip is required to run internal, please check what the Output tab is found.
Second, all queries from the IDE are now recorded in a text file. To open this file, go to Help | Display the SQL log.
New SQL formatting program
Thank you for sharing your idea for SQL style! We hope that DataGrip can accommodate more different code styles. The new SQL formatting program is the feature we strongly needs feedback, so please try it, if your specific case is not covered, please tell us. We are still working hard to add new terms.
You may already know that you can create a custom code style solution. Now, any of them can be specifically used for each data source. To do this, go to the Options tab of the data source properties.
Run stored procedure
Select "Execute" from the context menu of the process. SQL code will be generated. Enter the value of the required parameters, then click OK. As you can see, we retrieve the output of this mysql process because we have SQL code to obtain result sets from the JDBC driver.
Query plan (optimized performance artifact)
The query plan map can now be used for the query plan based on the chart. To view it, click the "Display Visualization" button on the toolbar after calling the description.
SQL editing
The context information is useful when the context is a large process in the package, and sometimes it is useful in its context, that is, the specific process or package that is being edited now. To do this, press SHIFT + CTRL + Q to view the context information.
Jump to close the bracket / quote starting from this version, you can navigate or close quotes outside the end parentheses by pressing the Tab key. Note that this is only valid when entering parameters or values for the first time. To customize this behavior of Tab, go to "Preference" | Edit | General | Smart Keys and select Jump to close Brand / Use the TAB key reference.
navigation
Before you use the Default Keyboard mapping, you cannot specify shortcuts from Find Operations. We have repaired this error, and now it applies to any keyboard mapping and any layout. A good reason reminds you, this is possible!
Navigation allows you to jump to any tables, views, or processes through the corresponding operation, or jump directly from the usage of the SQL code to any table, view, or procedure.
In general, DataGrip is a comprehensive database IDE for administrators and SQL developers. It has a practical function, supports DB2, Derby, H2, MySQL, Oracle, PostgreSQL, SQL Server, SQLLITE, and SYBASE and other online mainstream relational database products, in addition to performing SQL, creating tables, creating indexes, and exporting data. In addition, there is a highlighted tip on the keyword, and the prompt to the field is also very intelligent.
Editor: lyn, read full article, original text title: Dry Navicat: This database management tool is solid!
Article Source: [Micro Signal: THEBIGDATA1024, WeChat public number: artificial intelligence and big data technology] Welcome to add attention! Please indicate the source of the article.
Our other product:
