DataGrip is a database management software launched 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 a simple and easy-to-use interface, developers will hardly encounter any difficulty in getting started.
JetBrains DataGrip 2020 Feature Data
Editor
Completion DataGrip provides context-sensitive code completion to help you write SQL code faster. Complete database objects that recognize table structures, foreign keys, and even the code you’re editing.
DataGrip detects possible errors in your code and suggests the best options to fix them dynamically. It immediately lets you know about open objects, uses keywords as identifiers, and always provides a solution to the problem.
The log updates
the full SQL log and now you will see every query that DataGrip runs in the console output. Whether it’s something your SQL or DataGrip needs to run internally, check out the Output tab to see what’s going on.
Second, all queries from the IDE are now logged in text files. To open this file, go to the Help | SQL logs are displayed.
New SQL Formatter
Thank you for sharing your thoughts on SQL styles with us! We hope that DataGrip will now accommodate more different code styles. The new SQL formatter is a feature we strongly need feedback on, so give it a try and let us know if your specific case isn’t covered. We are still working on adding new provisions.
As you probably already know, you can create custom code style schemes. Now, any of them can be dedicated to each data source. To do this, go to the Options tab of the data source properties:
run the stored procedure
Select Execute from the context menu of the procedure. SQL code will be generated. Enter values for the required parameters, 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 (an artifact to optimize performance)
The chart-based view of the query plan graph is now available for query plans. To view it, click the Show Visualization button on the toolbar after invoking the instruction plan:
SQL Edit
.” context informationWhen editing a large procedure in a package, it is sometimes useful to flush memory in its context, that is, the specific procedure or package that is now being edited. To do this, press Shift+Ctrl+Q to view the contextual information.
Skip to Close Parentheses/Quotes Outside of this release, you can navigate outside the closing parentheses or close the quotes by pressing the Tab key. Note that this only works the first time you enter a parameter or value. To customize this behavior of the tab, go to the Preferences | Edit | General | Smart key and select Jump to close outside parentheses/use Tab key reference.
navigation
Previously, you could not specify a shortcut from Find Action if you used the default keyboard mapping. We’ve fixed this bug and now it works on any keyboard map and any layout. A good reason to remind you that it is possible!
Navigation allows you to jump to any table, view, or procedure
by name through the corresponding action, or jump directly from the usage in SQL code to any table, view, or procedure.
Overall, DataGrip is a comprehensive database IDE for administrators and SQL developers. It has practical functions, supporting DB2, Derby, H2, MySQL, Oracle, PostgreSQL, SQL Server, Sqllite and Sybase and other mainstream relational database products on the Internet, in addition to performing SQL, creating tables, creating indexes and exporting data and other common functions, but also on keywords highlight hints, and field hints are also very intelligent!
end
public number (zhisheng) reply to Face, ClickHouse, ES, Flink, Spring, Java, Kafka, Monitoring < keywords such as span class="js_darkmode__148"> to view more articles corresponding to keywords.
like + Looking, less bugs 👇