Skip to content
Install

Databases

GridGain Database Management in VS Code

Overview

Section titled “Overview”

GridGain is a distributed in-memory computing platform built on Apache Ignite. DBCode connects to its JDBC thin-client endpoint (default port 10800) and works the same way as the Apache Ignite driver. Pick the version matching your cluster:

  • GridGain 8.x connects with GridGain’s own JDBC client, which DBCode downloads the first time you connect.
  • GridGain 9.x connects with the Apache Ignite 3.x JDBC client.

All GridGain and Apache Ignite connections in a VS Code session share one Java runtime, so a GridGain 8.x connection can’t share a session with GridGain 9.x or Apache Ignite connections. GridGain 9.x and Apache Ignite connections can be open together in any order. When a connection can’t open for this reason, DBCode says so; restart VS Code and connect to it first.

The driver requires a Java runtime (JDK 11 or later for GridGain 9.x, JDK 9 or later for 8.x) on your machine.

Connecting

Section titled “Connecting”

To connect to GridGain in DBCode:

  1. Open the DBCode extension and select Add Connection.
  2. Select GridGain as the database type.
  3. Choose the GridGain Version (8.x or 9.x) that matches your cluster.
  4. Enter the host and thin-client port. The default port is 10800.
  5. Enter a username and password if your cluster has authentication enabled.
  6. Optionally, turn on Enable SSL/TLS when your cluster’s thin-client endpoint serves TLS. DBCode then encrypts the connection and verifies the server’s certificate against the trusted certificates of the Java runtime that runs the driver.
  7. Optionally, configure an SSH tunnel.
  8. Save the connection and open it from the DB Explorer.

User tables live in the PUBLIC schema; the system views are read-only, under the SYS schema on 8.x and the SYSTEM schema on 9.x.

Supported features

Section titled “Supported features”

GridGain supports the same feature set as Apache Ignite: running SQL, the visual query builder, browsing schemas, tables (with columns, primary keys, and indexes) and the system views, row editing, EXPLAIN execution plans, UUID/binary values, and server monitoring with Kill Query. Transactions and creating schemas are available on 9.x, and table row counts on 8.x with Update Statistics turned on. See the Apache Ignite page for the full feature table and SQL examples.

For cluster setup and SQL reference information, see the GridGain documentation.