DataGrip, a database management tool, can manage multiple mainstream databases (SQL Server, MySQL, Oracle, etc.) at the same time.

Time:2019-4-27

Preface

DataGripJet Brains is a database management tool (yes, it’s Jet Brains, it must be a boutique). DataGrip integrates the connection and management of current mainstream databases (such as: SQL Server, MySQL, Oracle, PostgreSQL, Sybase, Sqlite, DB2, Azure, etc.). Let developers or database administrators manage databases of many different products in one manager.

DataGrip features

Intelligent Query Console

DataGrip, a database management tool, can manage multiple mainstream databases (SQL Server, MySQL, Oracle, etc.) at the same time.

DataGrip allows you to execute queries in different modes and provides local history to track and save all your query activities, free from loss and easy re-query.

Efficient Architectural Navigation

You can jump to any table, view, or stored procedure by corresponding operations or directly from usage in SQL code.

Detailed implementation plan analysis

Let you have a deeper understanding of how your query works and how the database engine behaves, so that your query can be more efficient.

DataGrip, a database management tool, can manage multiple mainstream databases (SQL Server, MySQL, Oracle, etc.) at the same time.

Intelligent Code Completion

DataGrip provides context-sensitive code awareness to help you write SQL code faster. Code awareness can sense the table structures, foreign keys, and even database objects that you are creating in the code you are editing.

DataGrip, a database management tool, can manage multiple mainstream databases (SQL Server, MySQL, Oracle, etc.) at the same time.

Instant Analysis and Rapid Repair

Instant analysis and quick fix: DataGrip can quickly detect possible errors in code and recommend the best options to dynamically fix them. It will let you know the unresolved objects immediately, use keywords as identifiers, and always provide solutions to problems.

DataGrip, a database management tool, can manage multiple mainstream databases (SQL Server, MySQL, Oracle, etc.) at the same time.

Restructuring in SQL Files and Architectures

DataGrip correctly resolves all references in SQL code and helps you refactor them. When you rename or alias, DataGrip updates their references throughout the file. The real table name in the database will also be updated when you rename the reference. There is even a preview of the usage of tables/views in views, stored procedures and functions.

DataGrip, a database management tool, can manage multiple mainstream databases (SQL Server, MySQL, Oracle, etc.) at the same time.

Version Control Integration

DataGrip provides unified support for all major version control systems at present, such as Git, SVN, Mercurial and so on.

DataGrip, a database management tool, can manage multiple mainstream databases (SQL Server, MySQL, Oracle, etc.) at the same time.

DataGrip has more features:

  • 1. Click here to see the official DataGrip video introduction to extract the password: thpk
  • 2. For more details, see https://www.jetbrains.com/dat…

本文来源至 码友网 《数据库管理工具神器-DataGrip,可同时管理不同产品的主流的数据库[SQL Server,MySQL,Oracle,Sqlite,PostgreSQL,DB2等]》