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.
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. Database Objects – DataGrip introspects all objects in your databases and displays them in folders grouped by schemas.It provides database introspection and various instruments for creating and modifying objects for the supported engines.
If the DBMS has a JDBC driver you can connect to it via DataGrip.