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.
Intelligent Query Console
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.
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.
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.
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.
Version Control Integration
DataGrip provides unified support for all major version control systems at present, such as Git, SVN, Mercurial and so on.
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等]》