Connect to the Database (CockroachDB Cloud)

$ cockroach sql \
--url='postgres://{username}:{password}@{globalhost}:26257/{cluster_name}.{database}?sslmode=verify-full&sslrootcert={path to the CA certificate}'

Where:

• {username} and {password} specify the SQL username and password that you created earlier.
• {globalhost} is the name of the CockroachDB Serverless host (e.g., free-tier.gcp-us-central1.cockroachlabs.cloud).
• {path to the CA certificate} is the path to the cc-ca.crt file that you downloaded from the CockroachDB Cloud Console.
• {cluster_name} is the name of your cluster.

For more information about how to use the built-in SQL client, see the cockroach sql reference docs.

import (
    "database/sql"
    "fmt"
    "log"
    _ "github.com/lib/pq"
)

db, err := sql.Open("postgres",
        "postgresql://{username}:{password}@{globalhost}:26257/bank?sslmode=verify-full&sslrootcert={path to the CA certificate}&options=--cluster={cluster_name}")
if err != nil {
    log.Fatal("error connecting to the database: ", err)
}
defer db.Close()

Where:

• {username} and {password} specify the SQL username and password that you created earlier.
• {globalhost} is the name of the CockroachDB Serverless host (e.g., free-tier.gcp-us-central1.cockroachlabs.cloud).
• {path to the CA certificate} is the path to the cc-ca.crt file that you downloaded from the CockroachDB Cloud Console.
• {cluster_name} is the name of your cluster.

For complete examples, see:

• Build a Go App with CockroachDB (pgx)
• Build a Go App with CockroachDB and GORM

import java.sql.*;
import javax.sql.DataSource;

PGSimpleDataSource ds = new PGSimpleDataSource();
ds.setServerName("{globalhost}");
ds.setPortNumber(26257);
ds.setDatabaseName("{cluster_name}.bank");
ds.setUser("{username}");
ds.setPassword("{password}");
ds.setSsl(true);
ds.setSslMode("verify-full");
ds.setSslrootCert("{path to the CA certificate}");
ds.setReWriteBatchedInserts(true); // add `rewriteBatchedInserts=true` to pg connection string
ds.setApplicationName("BasicExample");

Where:

• {username} and {password} specify the SQL username and password that you created earlier.
• {globalhost} is the name of the CockroachDB Serverless host (e.g., free-tier.gcp-us-central1.cockroachlabs.cloud).
• {path to the CA certificate} is the path to the cc-ca.crt file that you downloaded from the CockroachDB Cloud Console.
• {cluster_name} is the name of your cluster.

For complete examples, see:

• Build a Java App with CockroachDB (JDBC)
• Build a Java App with CockroachDB and Hibernate

import psycopg2

conn = psycopg2.connect(
    database='bank',
    user='{username}',
    password='{password}'
    sslmode='verify-full',
    sslrootcert='{path to the CA certificate}',
    port=26257,
    host='{globalhost}',
    options="--cluster={cluster_name}"
)

Where:

• {username} and {password} specify the SQL username and password that you created earlier.
• {globalhost} is the name of the CockroachDB Serverless host (e.g., free-tier.gcp-us-central1.cockroachlabs.cloud).
• {path to the CA certificate} is the path to the cc-ca.crt file that you downloaded from the CockroachDB Cloud Console.
• {cluster_name} is the name of your cluster.

For complete examples, see:

• Build a Python App with CockroachDB (psycopg2)
• Build a Python App with CockroachDB and SQLAlchemy
• Build a Python App with CockroachDB and Django