- Green versionView
- Green versionView
- Green versionView
- Green versionView
Basic introduction to JetBrains DataGrip
JetBrains, a software company from the Czech Republic, has released a new heavyweight product DataGrip. Known as the Swiss Army Knife of databases and SQL. The predecessor of DataGrip, 0xDBE, has been released for more than a year. This is also the development version provided by JetBrains to the majority of users. Each version has a certain period of use. After expiration, users can download the new development version from the JetBrains website. After a long period of development, the new product DataGrip is finally available. Like other products in the JetBrains product line, DataGrip is available for Windows, Linux, and Mac. In addition, other JetBrains products such as Intellij IDEA have also integrated DataGrip through plug-ins, which makes it easier for developers to operate databases.
JetBrains DataGrip software features
1.Enjoy the fun of database work
Try our new DataGrip, a database IDE tailored to meet the specific needs of professional SQL developers.
2. Intelligent query console
Allows you to execute queries in different modes and also provides local history so you can keep track of all your activities and avoid losing your work.
3. Efficient mode navigation
Enables you to jump directly into any table, view or procedure based on its name, through the corresponding operation, or directly from its use in SQL code.
4.Explain the plan
Gives you a deeper understanding of how queries work and the behavior of the database engine, making your queries more efficient.
5. Intelligent code completion
DataGrip provides context-aware code completion to help you write SQL code faster. Completion knows the structure of tables, foreign keys, and even database objects created in the code you're editing.
6. Online analysis and quick repair
DataGrip detects possible defects in the code and provides the best fix online. It uses keywords as identifiers to immediately let you know about unresolved objects and always provides a way to fix the problem.
7. Still refactorable in sql files and schemas
DataGrip correctly resolves all references in SQL code and helps you refactor them. When you rename a variable or alias, all uses of it are automatically updated throughout the file. When you rename a reference to a table in a query, the actual name of the table in the database is also updated. You can even preview how the table/view will be used in other views, stored procedures, and functions.
8. Version control integration
We provide consistent support for all major version control systems: Git, SVN, Mercurial, and many others.
JetBrains DataGrip function introduction
1. Write SQL efficiently and eliminate repetitive coding work
With JetBrains DataGrip you can write code faster with code completion features. Just enter the name of a database object, identifier, or variable, and DataGrip will provide a list of matches. DataGrip can sense the dependencies required to complete the JOIN clause, provide the parameter types required for functions and procedures, and can also provide the table structure of the INSERT statement. DataGrip provides Live Templates for generating common parts of statements. You can use default values or create new values.
2. Navigate between codes and rename as you type
DataGrip can parse out object references in SQL files. If variables or aliases are renamed, all uses of them will be renamed accordingly. If a database object is renamed in SQL, it will also be renamed in the actual database. DataGrip can correctly parse all references in SQL code and help you refactor it.
3. Process data and explore relationships
You can add, delete, and clone data rows through the powerful table editor. By filtering text fields, you can view only the data you need without writing WHERE clauses. Another way to find the data you need is to use text search. Text search is a very useful feature if you don't know which column contains the data you are looking for. Regular expressions can be used in text searches. Foreign key data navigation allows you to go to the data referenced by the current row and vice versa.
4. Analyze query and compare results
When you click the Execute button, you can choose what to do with DataGrip—execute a subquery, execute an outer query, or execute the entire script. Want to execute only a specific section of code? Just select it and execute it. DataGrip also provides an execution plan, and its result set is similar to the table editor, including the same options, such as adding/removing rows, text search, and data navigation. Two result sets can be compared in the diff viewer.
JetBrains DataGrip update log
1. Fix bugs in the previous version
2. Optimize some functions
Huajun editor recommends:
If you are dazzled by the introduction of so many functions above, then download JetBrains DataGrip quickly. This site also providesSQL Server automatic installer,Data Loader,SQLyog,access tools,DBF CommanderWaiting for you to download.
Useful
Useful
Useful