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 save query 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.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 save query 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.
0 kommentar(er)
