Since the big bang in the data technology landscape happened a decade and a half ago, giving rise to technologies like Hadoop, which cater to the four ‘V’s. — volume, variety, velocity, and veracity there has been an uptick in the use of databases with specialized capabilities to cater to different types of data and usage patterns. You can now see companies using graph databases, time-series databases, document databases, and others for different customer and internal workloads. Apache Cassandra™ is  a wide-column, NoSQL database that is ideal when used for  append-only, write-intensive workloads that capture data from IoT sensors, GPS devices, transaction logs, any time-series applications, and more. A lot of these applications need to be coupled with visualization engines for creating reports and dashboards. As most of the visualization libraries are written in JavaScript, using Node.js to interact with the database and the visualization engine is a good idea. In this tutorial, you will learn how to use a small Node.js application to get cryptocurrency data from an API and continuously ingest that into Cassandra for downstream consumption. You can feed data from Cassandra to a wide variety of applications such as a cryptocurrency trading platform, cryptocurrency price monitoring and alerting, and so on. Without further ado, let’s get going. Prerequisites Before getting started with the tutorial, you’ll need the following: 1. — a local Node.js installation that comes with npm — the default package manager. Node.js 2. — to clone the that contains the code for this tutorial. Git GitHub repository 3. — for a serverless, Cassandra database to use with an API or driver. DataStax Astra spinning up 4. — a Node.js library to access cryptocurrency data. CoinGecko-API CoinGecko Clone the Repository You can clone the GitHub repository for Cassandra Node.js Cryptotracker using git clone command: git clone git@github.com:kovid-r/cassandra-nodejs-cryptotracker.git After cloning the repository, the first order of business is to install the Node.js dependencies specified in the package.json and package-lock.json files. npm will take care of installing the dependencies using the following command in the repository directory: npm install These instructions are also present in the file in the repository. README Configure Astra Create a Database Before running the application, you need to for DataStax Astra, which is powered by Apache Cassandra and . sign up spin up a Cassandra database Although the price information changes as you change cloud providers and regions, for a Proof of Concept, or even small production applications, you won’t need any more than the free $25 credit per month that Astra already offers its users. This gets you roughly 40 GB of free storage, 40 million reads, and 5 million writes. No credit card is required to sign up, just login with Google or GitHub. Click on the Create Database option, and it will lead you to the following page where you can create a database on any of the three leading cloud providers globally — Google Cloud, AWS, and Azure. You will need to provide the database name (nodeapp) and the keyspace name (coingecko). Please use the specified names. Initialize the Database To access the database for the first time, use the CQLSH in-browser console, as shown in the image below. Use this console to to create a keyspace if it doesn't exist in the database, and to create a table in the specified keyspace. The structure of the table is predefined in the initialize.sql file in the repository. The data from the CoinGecko API calls will land in this table. run the two commands Download the Secure Bundle You need to download the file to your Node.js application directory. Make sure that your browser doesn’t unzip the file while downloading it. DataStax Secure Bundle zip You will need to provide the path to this file to the configuration in a later step; for more information about the Secure Bundle, head over to . DataStax Astra’s official documentation Generate an Authentication Token The next step is to generate an authentication token. To do that, click the Billing option on the top menubar. You will land on a screen shown in the image below: Go to the Token Management option in the left menubar and choose the R/W User role in the Select Role drop-down menu and press Generate Token. You will see the following screen with your authentication token. Download the Client ID, Client Secret, and Token in a CSV, or copy them directly. Run Cryptotracker Use npm config for Authentication Now, we are good to go ahead and run our Node.js Cryptotracker application. In this tutorial, we are using the config package to avoid storing token information in our code. We have included a file in the repository config/default.json which looks something like this: To authenticate, replace the values for secureConnectBundle, username, and password in this JSON file as instructed, but make sure you DO NOT commit this to your codebase. Run npm start If you have configured everything correctly, you should be able to run the following command from your Node.js application directory now: npm start The Node.js application will run for 40 seconds and hit the CoinGecko API. You can change that by going to these two lines in the index.js file and reconfigure the main function call. After running npm start a couple of times, you can head over to the Astra website to see how much of your quota is used, as shown in the image below: You can also log into your CQL console and write a CQL query to fetch some data from the coingecko.coin_prices table as shown in the image below: If you want to capture the price for other coins, you can pass different parameters to the getCoinPrice method arguments — coinName and coinSymbol: Connect Other Applications Other applications can consume data from Cassandra. DataStax Astra for C#, Python, Node.js, Java, and C++. You can seamlessly integrate popular visualization engines like Grafana with Astra. supports drivers Conclusion In this tutorial, you learned how to use Cassandra as a time-series database for capturing cryptocurrency price movements using a Node.js application. You also learned how to set up a DataStax Astra database in the cloud using your preferred cloud provider. Please reach out if you have any questions or feedback at or connect with me on LinkedIn. kovid.rathee@gmail.com Learn More: 1. Git 2. Node.js 3. DataStax Astra 4. CoinGecko 5. CoinGeckoAPI

Apache

Fetch

Google

Velocity

2022 - No No No Nodejs

Read My Stories

Nominated for 2022 - No No No Nodejs

Too Long; Didn't Read

Developers: Build Less. Deliver More. [Learn how]	

Build A Crypto Price Tracker using Node.js and Cassandra

Too Long; Didn't Read

Companies Mentioned

Kovid Rathee

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

Build A Crypto Price Tracker using Node.js and Cassandra

Too Long; Didn't Read

Companies Mentioned

Kovid Rathee

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES