You can download the DDL and data scripts here. Step 4: Create the Northwind Databaseįor the purposes of this blog post we’ll be using the Northwind sample database. Click the OK button and you are now ready to start exploring DataGrip. Of course, it is always a good idea to test the connection to make sure everything is set up correctly before proceeding. This option makes DataGrip’s PostgreSQL connector use standard JDBC metadata as opposed to PostgreSQL specific metadata. YugabyteDB does not use PostgreSQL’s system columns given that these functions are handled by the DocDB storage engine of YugabyteDB. On the “Options” tab you’ll want to check the “Introspect using JDBC metadata” box. Database User: “yugabyte” is YugabyteDB’s default user.Port: 5433 (Note that PostgreSQL’s default port assignment is 5432, while YugabyteDB uses 5433).Click on “+” > Datasource > PostgreSQL.Ĭonfigure the connection to YugabyteDB using the following values: Next, you’ll want to configure a new database connection. Step 3: Connecting DataGrip to YugabyteDB The installation is as simple on Mac as you’d expect. You can verify that your cluster is up and running by checking out the YugabyteDB Admin UI which is located at:ĭataGrip can be downloaded from their website here:Īs of this writing, version 2019.3.3 is what was tested against YugabyteDB. With the command below, create a 3 node cluster with a replication factor of 3. Configure Loopback AddressesĪdd a few loopback IP addresses for the various YugabyteDB processes to use. Make sure to check the Quickstart Guide for the latest version. Note: At the time of this writing, 2.0.11 is the latest release of YugabyteDB. In the following section we’ll cover the basic steps for getting up and running in just a few minutes with a local 3 node cluster on your Mac laptop. Although for the purposes of this blog post we’ll be installing everything on a macOS, both YugabyteDB and DataGrip support most major operating systems.įor complete instructions on how to get up and running on a variety of platforms including prerequisites, check out our Quickstart Guide. Ok, let’s dive in and get DataGrip installed and connected to a YugabyteDB cluster! Step 1: Install a Local YugabyteDB Clusterīefore we get into DataGrip, you’ll need to setup YugabyteDB and install a sample database. JetBrains offers a 30 day free trial, so you can try all the features before deciding if you’d like to sign on for a commercial subscription, which is very reasonably priced. Additional Features – DataGrip also has a query console, diff viewer, import/export wizards, VCS, and ER diagramming capabilities.Writing SQL – DataGrip boasts a smart text editor, code completion, automatic code generation, code analysis, refactoring, and a variety of visual themes to suit your preferences.Navigate to the symbol action which lets you find objects by their name. Navigation – Quick navigation takes you to an object independent of whether it has just been created in your code, or it has already been read from a database.Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the data editor. Database Editor – The powerful data editor lets you add, remove, edit, and clone data rows. It also provides a UI for adding and editing tables, columns, indexes, constraints, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |