GridGain Database Management in VS Code

Overview

GridGain is a distributed in-memory computing platform built on Apache Ignite. It is protocol-compatible with Apache Ignite, so DBCode connects through the same JDBC thin client (default port 10800) and provides the identical experience as the Apache Ignite driver. Pick the version matching your cluster:

• GridGain 8.x, on the Apache Ignite 2.x protocol.
• GridGain 9.x, on the Apache Ignite 3.x protocol.

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

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. Configure optional TLS or an SSH tunnel.
7. 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

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, and UUID/binary values. Transactions are not available through the 8.x (Ignite 2.x) thin client. See the Apache Ignite page for the full feature table and SQL examples.

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