What steps are needed to link my Javascript application with Amazon Keyspaces?

Question

What steps are needed to link my Javascript application with Amazon Keyspaces?

I am a beginner looking for assistance with extracting data from Amazon keyspaces tables on a small demo website with 4 categories and 4 subcategories. I have created the tables but can't find a tutorial, please help.

The goal is to display database data on the website, which was created using Visual Studio.

javascript visual-studio-code cassandra amazon-keyspaces datastax-node-driver

Answer 1

Answer №1

Check out the Node.js driver for Cassandra.

Take a look at this code snippet that demonstrates how to connect to Amazon Keyspaces:

const cassandra = require('cassandra-driver');
const fs = require('fs');
const auth = new cassandra.auth.PlainTextAuthProvider('ServiceUserName', 'ServicePassword');
const sslOptions1 = {
    ca: [
        fs.readFileSync('path_to_file/sf-class2-root.crt', 'utf-8')],      
            host: 'cassandra.us-west-2.amazonaws.com',
                rejectUnauthorized: true
        };
const client = new cassandra.Client({
    contactPoints: ['cassandra.us-west-2.amazonaws.com'],
        localDataCenter: 'us-west-2',
        authProvider: auth,
        sslOptions: sslOptions1,
        protocolOptions: { port: 9142 }
    });

const query = 'SELECT * FROM system_schema.keyspaces';
 
client.execute(query)
    .then( result => console.log('Row from Keyspaces %s', result.rows[0]))
    .catch( e=> console.log(`${e}`));

Make sure to download the certificate for your database. For detailed instructions, refer to this guide.

If you're interested, we offer free tutorials on developing apps for Cassandra at datastax.com/dev, including example apps + complete code in Javascript and other languages. Enjoy!

Answer 2

Check out the Node.js driver for Cassandra.

Take a look at this code snippet that demonstrates how to connect to Amazon Keyspaces:

const cassandra = require('cassandra-driver');
const fs = require('fs');
const auth = new cassandra.auth.PlainTextAuthProvider('ServiceUserName', 'ServicePassword');
const sslOptions1 = {
    ca: [
        fs.readFileSync('path_to_file/sf-class2-root.crt', 'utf-8')],      
            host: 'cassandra.us-west-2.amazonaws.com',
                rejectUnauthorized: true
        };
const client = new cassandra.Client({
    contactPoints: ['cassandra.us-west-2.amazonaws.com'],
        localDataCenter: 'us-west-2',
        authProvider: auth,
        sslOptions: sslOptions1,
        protocolOptions: { port: 9142 }
    });

const query = 'SELECT * FROM system_schema.keyspaces';
 
client.execute(query)
    .then( result => console.log('Row from Keyspaces %s', result.rows[0]))
    .catch( e=> console.log(`${e}`));

Make sure to download the certificate for your database. For detailed instructions, refer to this guide.

If you're interested, we offer free tutorials on developing apps for Cassandra at datastax.com/dev, including example apps + complete code in Javascript and other languages. Enjoy!

Answer 3

Answer №2

Roshni, you can find examples on how to connect to Keyspaces in the programming language of your choice at this GitHub repository - https://github.com/aws-samples/amazon-keyspaces-example. Below is a snippet of sample code for your reference:

// Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.
// SPDX-License-Identifier: MIT-0

// Define Variables
const cassandra = require('cassandra-driver');
const fs = require('fs');
const sigV4 = require('aws-sigv4-auth-cassandra-plugin');
// Custom retry policy for AmazonKeyspaces to retry on the same host
const custom_retry = require('./retry/AmazonKeyspacesRetryPolicy.js');
// Maximum number of retry attempts for custom retry
const Max_retry_attempts = 10;
require('dotenv').config();
const region = process.env.AWS_REGION;
const accessKey = process.env.AWS_ACCESS_KEY_ID;
const secretKey = process.env.AWS_SECRET_ACCESS_KEY;

// Check if environment variables are defined
if (!region) {
    console.log("Region is not set. Please set the environment variable AWS_REGION");
    process.exit(1);
}

if (!accessKey) {
    console.log("Access key is not set. Please set the environment variable AWS_ACCESS_KEY_ID");
    process.exit(1);
}

if (!secretKey) {
    console.log("Secret key is not set. Please set the environment variable AWS_SECRET_ACCESS_KEY");
    process.exit(1);
}

const auth = new sigV4.SigV4AuthProvider({
    region: region,
    accessKeyId: accessKey,
    secretAccessKey: secretKey
});

const host = 'cassandra.' + region + '.amazonaws.com';
const sslOptions = {
    ca: [
        fs.readFileSync(__dirname + '/resources/sf-class2-root.crt')
    ],
    host: host,
    rejectUnauthorized: true
};

const client = new cassandra.Client({
    contactPoints: [host],
    localDataCenter: region,
    authProvider: auth,
    sslOptions: sslOptions,
    queryOptions: { isIdempotent: true, consistency: cassandra.types.consistencies.localQuorum },
    policies: { retry: new custom_retry.AmazonKeyspacesRetryPolicy(Max_retry_attempts) },
    protocolOptions: { port: 9142 }
});

const query = 'SELECT * FROM system_schema.keyspaces';

const result = client.execute(query).then(
    result => console.log('Row from Keyspaces %s', result.rows[0])
).catch(
    e => console.log(`${e}`)
);

Promise.allSettled([result]).finally(() => client.shutdown());

Answer 4

Roshni, you can find examples on how to connect to Keyspaces in the programming language of your choice at this GitHub repository - https://github.com/aws-samples/amazon-keyspaces-example. Below is a snippet of sample code for your reference:

// Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.
// SPDX-License-Identifier: MIT-0

// Define Variables
const cassandra = require('cassandra-driver');
const fs = require('fs');
const sigV4 = require('aws-sigv4-auth-cassandra-plugin');
// Custom retry policy for AmazonKeyspaces to retry on the same host
const custom_retry = require('./retry/AmazonKeyspacesRetryPolicy.js');
// Maximum number of retry attempts for custom retry
const Max_retry_attempts = 10;
require('dotenv').config();
const region = process.env.AWS_REGION;
const accessKey = process.env.AWS_ACCESS_KEY_ID;
const secretKey = process.env.AWS_SECRET_ACCESS_KEY;

// Check if environment variables are defined
if (!region) {
    console.log("Region is not set. Please set the environment variable AWS_REGION");
    process.exit(1);
}

if (!accessKey) {
    console.log("Access key is not set. Please set the environment variable AWS_ACCESS_KEY_ID");
    process.exit(1);
}

if (!secretKey) {
    console.log("Secret key is not set. Please set the environment variable AWS_SECRET_ACCESS_KEY");
    process.exit(1);
}

const auth = new sigV4.SigV4AuthProvider({
    region: region,
    accessKeyId: accessKey,
    secretAccessKey: secretKey
});

const host = 'cassandra.' + region + '.amazonaws.com';
const sslOptions = {
    ca: [
        fs.readFileSync(__dirname + '/resources/sf-class2-root.crt')
    ],
    host: host,
    rejectUnauthorized: true
};

const client = new cassandra.Client({
    contactPoints: [host],
    localDataCenter: region,
    authProvider: auth,
    sslOptions: sslOptions,
    queryOptions: { isIdempotent: true, consistency: cassandra.types.consistencies.localQuorum },
    policies: { retry: new custom_retry.AmazonKeyspacesRetryPolicy(Max_retry_attempts) },
    protocolOptions: { port: 9142 }
});

const query = 'SELECT * FROM system_schema.keyspaces';

const result = client.execute(query).then(
    result => console.log('Row from Keyspaces %s', result.rows[0])
).catch(
    e => console.log(`${e}`)
);

Promise.allSettled([result]).finally(() => client.shutdown());

What steps are needed to link my Javascript application with Amazon Keyspaces?

Answer №1

Answer №2

Similar questions

The HTML modal window is experiencing loading issues

Comparing the size of a MongoDB array to another field in a document: how can it be done?

Algorithm for detecting collisions in Javascript

Running only failed tests in Protractor can be achieved by implementing a custom script that

Send two arguments to a personalized validation function using express-validation

What is the process of making circle or square shapes with text inside using React, without the use of SVG images?

Use multer-ftp to change the name of a file

Tips for increasing a cell in AG Grid React table:

Exploring face detection with Three.js

Eliminate repeated elements in a selection using an AngularJS custom directive

`How can I trigger a JavaScript event when the content of an input field is modified?`

conceal the mustard-colored dots within the overlay

"Seamlessly Integrating AngularJS with WebGL for Stunning Canvas Inter

Uh-oh! An unexpected type error occurred. It seems that the property 'paginator' cannot be set

Refreshing data in AngularJs is like pressing the reset button for

What is the proper way to invoke a variable-function in Node.js?

Can one verify if an Angular application currently has active app modules running?

Transmit an unmodifiable array using JSON and Ajax

Enhancing vanilla HTML elements with custom props using React

How can I prevent overwriting previous input data in LocalStorage using Draftjs?