JavaScript

This section provides a quick overview of available node.js modules and drivers for CrateDB Cloud.

node-postgres

node-postgres is a collection of node.js modules for interfacing with a CrateDB Cloud database.

Example implementation will look like this:

const { Client } = require("pg");

const crateClient = new Client({
  host: "<name-of-your-cluster>.cratedb.net",
  port: 5432,
  user: "admin",
  password: "<PASSWORD>",
  ssl: true,
});

(async () => {
  await crateClient.connect();
  const result = await crateClient.query("SELECT name FROM sys.cluster");
  console.log(result.rows[0]);
})();

For more information see node-postgres documentation.

node-crate

node-crate is an independent node.js driver implementation for CRATE using the _sql endpoint REST API.

Example implementation will look like this:

const crate = require("node-crate");

crate.connect(`https://admin:${encodeURIComponent("<PASSWORD>")}@<name-of-your-cluster>.cratedb.net:4200`);

(async () => {
  const result = await crate.execute("SELECT name FROM sys.cluster");
  console.log(result.rows[0]);
})();

For more information see node-crate documentation.