#Datagrip sql how to#
#Datagrip sql install#
#Datagrip sql driver#
#Datagrip sql code#

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.

#Datagrip sql how to#

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.

#Datagrip sql install#

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.

#Datagrip sql code#

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.

#Datagrip sql driver#

If the DBMS has a JDBC driver you can connect to it via DataGrip.

Support for Multiple Databases – DataGrip is the multi-engine database environment.

Introducing DataGripĭataGrip boasts many of the must-have features you’d expect from a database GUI tool including: Yugabyte’s SQL API (YSQL) is PostgreSQL wire compatible. What’s YugabyteDB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. In this post we’ll show you how to get DataGrip connected to a YugabyteDB cluster, use it to build a sample database, load it up with data and browse it. And because YugabyteDB is PostgreSQL compatible, getting DataGrip to work with a distributed SQL database is relatively simple. DataGrip from JetBrains is a well-rounded, visual database tool that supports almost 20 SQL and NoSQL databases from a single interface. If you’re a database developer, you know the time saving value of an IDE in helping you create and navigate database objects, plus query and edit data from single UI.