@relationalai/rai-sdk-javascript NPM

The RelationalAI Software Development Kit for JavaScript

The RelationalAI (RAI) SDK for JavaScript enables developers to access the RAI REST APIs from JavaScript. The SDK provides first class TypeScript support.

You can find RelationalAI product documentation at https://docs.relational.ai
You can learn more about RelationalAI at https://relational.ai

Getting started

Requirements

Node.js 14+

Installing the SDK

Install

$ npm install @relationalai/rai-sdk-javascript

Create a configuration file

In order to run the examples and, you will need to create an SDK config file. The default location for the file is $HOME/.rai/config and the file should include the following:

[default]
host = azure.relationalai.com
client_id = <your client_id>
client_secret = <your client secret>

# the following are all optional, with default values shown
# port = 443
# scheme = https
# client_credentials_url = https://login.relationalai.com/oauth/token

Client credentials can be created using the RAI console at https://console.relationalai.com/login

You can copy config.spec from the root of this repo and modify as needed.

Usage

The package provides readConfig helper that reads the configuration file

import { Client, readConfig } from '@relationalai/rai-sdk-javascript';

const config = await readConfig();
const client = new Client(config);

const result = await client.listEngines();

or you can build the config object

import { Client, ClientCredentials } from '@relationalai/rai-sdk-javascript';

const credentials = new ClientCredentials(
  'your client_id',
  'your client_secret',
  'https://login.relationalai.com/oauth/token',
);
const config = {
  credentials,
  host: 'azure.relationalai.com',
  scheme: 'https',
  port: '443',
};
const client = new Client(config);

const result = await client.listEngines();

Examples

Each of the example files in the ./examples folder is standalone and can be run from the command line, eg:

$ npm run example -- ./examples/listEngines.ts

$ npm run example -- ./examples/runQuery.ts -d dbName -e engineName -c "def output = 1 + 2"

Data Types

ResultTable maps Rel data types to their corresponding JavaScript equivalents. Full mapping:

Rel Data Type	JS Data Type
Int8, Int16, Int32	number
Int64, Int128	bigint
UInt8, UInt16, UInt32	number
UInt64, UInt128	bigint
Float16, Float32, Float64	number
Rational8, Rational16, Rational32	`{ numerator: number; denominator: number; }`
Rational64, Rational128	`{ numerator: bigint; denominator: bigint; }`
FixedDecimal all bit sizes(16, 32, 64, 128)	decimal.js
Char	string
String	string
DateTime, Date	Date
Year, Month, Week, Day	bigint
Hour, Minute, Second, Millisecond, Microsecond, Nanosecond	bigint
Bool	boolean
FilePos	bigint
Missing	null
AutoNumber	bigint
UUID	string
SHA1	string