Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use DataGrip, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

What is DataGrip?

DataGrip is a visual software that connects to a database, just like Navicat.

DataGrip is produced by JetBrains, the same company that developed IntelliJ IDEA.

Write on the front

Current time: 2020-03-27

Basically everyone I know is using Navicat,Navicat. It works really well.

But DataGrip is really easy to use, and I think the design of DataGrip interface is more beautiful, and the prompt function when writing SQL statements is also very powerful, which is really much more powerful than Navicat. But if you are used to using Navicat, it will feel very awkward. In this article, I will talk about these awkward places and use DataGrip to connect to our database.

Download and install

Don't say it, because most people should have used IDEA if they use this software, and its download and installation is more or less the same as IDEA.

Just to say one thing, when you install on the Ubuntu platform, you don't have to create icons like IDEA does during the installation process. In its settings, there is a shortcut to set the icon, but this shortcut is not set by default, just set the shortcut, and then use this shortcut to create an icon.

How to connect to my database

Why didn't you have that small window when you first opened it?

Probably because of the use of IDEA, I always want to be similar to IDEA when using DataGrip.

When we open IDEA for the first time, a small window appears for us to create the project, like this

But when you open DataGrip, you don't have this interface, but go directly to the software.

This is because DataGrip creates a project for us by default after installation, which is in the default cache directory of DataGrip, and the default project location in mac is / Users/lyx/Library/Preferences/DataGrip2019.3/projects/default

Let's just connect to the database directly in this default project. You can connect to databases on multiple servers in one project, just like me, we have connected databases on four servers in this default project.

Of course, if we want to rebuild the project ourselves, we will not talk about how to create it here. It is very simple. How to connect to the database and click this button

Select Data Source and then select the type of database you want to connect to. And then you'll see the window below.

I'm sure you know what to fill in this window. What you need to note is that Database and URL do not need to be filled in. Click Test Connection to test whether the connection can be made.

After clicking, you will download the Jar of Java connecting to the database, which is developed by Java, because this is the first time you need to download the Jar package. It may fail. Just try it a few more times.

At this time, the awkward side is coming. After the test has passed, do not click Apply or OK to connect.

Select the Database to connect to

According to our normal thinking, when my options are filled in, I click Apply or OK, I should connect to my database, and then list all the Database in the database so that I can view it freely.

But if you click Apply or OK directly after passing the test, you will find that there is no Database in the connected database, and we need to do this next step.

After the test passes, we click Schemas. In DataGrip, Schemas is equivalent to Database. The purpose of the click button is to see how many Databases there are in our database, and then we choose which Databases to display in the connected database.

But there is also a very awkward place, that is, after you click this button, nothing may be displayed, because at this time DataGrip is going to connect to your database to show which Database (although it has already been connected during the test), but this connection does not have any hint, it will not tell you that it is connecting to the database and ask you to wait for a while.

After a while, when the connection is complete, it will show which Database are in our database. Take a look at the following two pictures.

Check the Database you want to connect to, and then click Apply or OK.

On the left, you can see the database we are connected to, as well as the Database we checked in the database.

Of course, to show which Database later can also be modified, how to modify it on its own, after getting started is very simple.

The above is all the contents of the article "how to use DataGrip". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.