Eric Hallow

This post is about harnessing the power of reliable blockchain data with real time query capability. We can index blockchain data directly from Ethereum nodes into Astra DB, resulting in a tougher backend code. Instead, we use the power of Astra DB&rsquo;s Ethereum Blockchain dataset in combination with Stargate API to make things simpler. Here, we use this data to build an application providing a real-time feed of every new NFT minted.
There are two guarantees in the crypto markets: massive volatility and the development of cutting-edge applications. Through bear markets and bull markets, developers continue building new, innovative solutions to problems in Web3. What&rsquo;s consistent through all of these applications is the need for reliable blockchain data with the real-time query capability. The Ethereum dataset of <a href="https://dtsx.io/3vm7J0U">DataStax Astra DB</a> provides a dependable source for all your data needs. In this article, I will show you application examples, building pain points, and how to get started with the dataset.&nbsp;
<h2>Building Applications</h2>
Crypto Wallets, Non-Fungible Token (NFT) marketplaces or Blockchain Explorers are just a few examples of applications utilizing blockchain data. There are endless opportunities to build applications after solving infrastructure problems. We have simplified that entire backend process by allowing developers to utilize APIs they are already familiar with.
We leveraged this to build a <a href="https://dtsx.io/3zdLUmF">real-time feed</a> of every new NFT mined. This wouldn&rsquo;t have been possible without Astra DB. The blockchain data is indexed directly from Ethereum Nodes into Astra DB after a new block is mined. This application makes API requests directly to Astra DB. No need to worry about nodes or remote procedure calls (RPC).&nbsp;
<img src="https://cdn.sanity.io/images/bbnkhnhl/production/a26f4a496c4a0879315832adbda5d2cb375dbd86-1204x760.png" alt="Astra-powered real-time NFT feed" width="1204" height="760" /> Figure 1: Astra-powered real-time NFT feed
<h2>The Pain of Building in Web3</h2>
If you want to develop a product built on Blockchain data, a wide variety of problems stand in your way. A lot of the data out there is not available in real time and is expensive. Blockchains are decentralized and immutable, but require a great deal of expertise to navigate. Most developers want to skip ahead of those problems and insert data into the frontend of their applications with simple API calls.
<h2>Difficulty Running Ethereum Nodes</h2>
 
Running your own Ethereum node / IPFS node adds a layer of complexity onto your application. By no means is it impossible, but the lack of quality documentation makes a workflow slow and painful. You will spend more time troubleshooting your node than developing the greater application. As the saying goes, &ldquo;There is no customer support in Web3.&rdquo; You will feel that pain as you &ldquo;trial-and-error&rdquo; your way through every problem you are trying to solve.&nbsp;
<h2>More RPC Calls and Costs</h2>
In order to pull all the necessary JSON data for any NFT, you will need to make a variety of different RPC calls. This makes your backend code 10x tougher to manage. After evaluating a few of the infrastructure options, the complexity keeps growing and we haven&rsquo;t even mentioned the additional costs. You can build this way, but there are simple, cheaper options to get your data.&nbsp;
The <a href="https://dtsx.io/3vm7J0U">Astra DB</a> Ethereum Blockchain dataset meets developers where they are now. With just a simple API call, you can pull all the necessary metadata equal to those 10+ RPC calls. Check out this GET request to the Ethereum Dataset below. Quick and easy. As a developer, this will be second nature to you.
<code>curl --request GET \ &nbsp; &nbsp; --url https://${ASTRA_DB_ID}-${ASTRA_DB_REGION}.apps.astra.datastax.com/api/rest/v2/keyspaces/${ASTRA_DB_KEYSPACE}/ETH/${ASTRA_ORG_ID}\ &nbsp; &nbsp; --header "x-cassandra-token: ${ASTRA_DB_APPLICATION_TOKEN}"</code>
<h2>Building with Ethereum Data</h2>
<a href="https://dtsx.io/3vm7J0U">Astra DB</a> has indexed the entire Ethereum blockchain. You can leverage speed, performance, and scalability directly into your application data. This will lower your barriers to entry and allow you to focus on building your product on top of a reliable source. Within just minutes, you can spin up a database with our NFT dataset and run queries.&nbsp;
<h3>Create Astra DB</h3>
<img src="https://cdn.sanity.io/images/bbnkhnhl/production/efb2da9704ebfd049ca92464b0621af41aaee4ee-1600x652.png" alt="Creating an Astra database" width="1600" height="652" /> Figure 2: Creating an Astra database
<h3>Load Ethereum Dataset in Astra DB</h3>
Create an entire database with all Ethereum data in your newly created database.
<img src="https://cdn.sanity.io/images/bbnkhnhl/production/9ce9953c43992d004647c2565ebffba6ab638d48-1600x286.png" alt="Creating a database with Ethereum data" width="1600" height="286" /> Figure 3: Creating a database with Ethereum data
<h3>CQL Query</h3>
Navigate to the CQL console in Astra. Explore the NFT dataset by running some simple CQL queries.
<img style="display: block; margin-left: auto; margin-right: auto;" src="https://cdn.sanity.io/images/bbnkhnhl/production/02292adea921fef2483fc9dc6fa722fc72b33668-1600x771.png" alt="Running a CQL query on the NFT dataset" width="1600" height="771" />Figure 4: Running a CQL query on the NFT dataset.
Turn on expand output and run this simple query to view the NFT data.
<code>token@cqlsh&gt; expand on; Now Expanded output is enabled token@cqlsh:eth_v2&gt; select * from nfts limit 5;</code>
The output will show all the necessary data associated with the NFTs. 
<code>&nbsp;contract_address | 0x05ba660296914719f089a36f933752fdb0d1ba16 token_id &nbsp; &nbsp; &nbsp; &nbsp; | 166 block_number &nbsp; &nbsp; | 14951160 metadata &nbsp; &nbsp; &nbsp; &nbsp; | {"name":"CyberModern Chapter 2 #166","description":"","image":"ipfs://QmZ6FqRfDs5L2kC4jyzZ1GpzsAsb3kDAEnNe5AbAqvZwhz/166.png","edition":166,"attributes":[{"trait_type":"Style","value":"Chimerism"},{"trait_type":"Palette","value":"Dark"},{"trait_type":"Mood","value":"Excited"},{"trait_type":"Scent","value":"Black pepper"},{"trait_type":"Scent","value":"Formalin"},{"trait_type":"Scent","value":"Rain"},{"trait_type":"Subject","value":"Beast"},{"trait_type":"Subject","value":"Pseudo-living"},{"trait_type":"Subject","value":"Supenatural phenomena"},{"trait_type":"Gallery","value":"Galerie Abercrombie"}]} name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | CyberModern owner_of &nbsp; &nbsp; &nbsp; &nbsp; | 0x0000000000000000000000000000000000000000000000000000000000000000 symbol &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | CYBERM token_standard &nbsp; | ERC721 token_uri&nbsp; &nbsp; &nbsp; &nbsp; | ipfs://QmUAbYu56oeyADm98HtkmpuZG1yjswf1bmG713yqBFMdET/166.json</code>
<h3>Connect your Application</h3>
You can integrate all this data into your application using our <a href="https://www.datastax.com/products/datastax-astra/apis">Stargate APIs</a>. Follow these simple steps in the connect tab to use your API of choice. With a few lines of code, you can pull all the NFT data into your application. 
<img src="https://cdn.sanity.io/images/bbnkhnhl/production/12ef0bfd184be94a95d996f59af6fa6ddbc70f2b-1007x665.png" alt="Steps to pull NFT data into your application" width="1007" height="665" /> Figure 5: Steps to pull NFT data into your application.
<h2>Conclusion</h2>
By following these steps, you have successfully connected and queried blockchain data indexed on Astra. You can leverage scaling, high availability, and <a href="https://dtsx.io/3viVzWI">Stargate APIs</a> to continue growing your project. Need help? Experienced developers staff the chat console in Astra DB to ensure your success with Ethereum data on Astra DB. Start building and we will help you along the way!&nbsp;
Subscribe to the <a href="https://dtsx.io/3aHZe9p">DataStax Tech Blog</a> for more developer stories. Check out our <a href="https://dtsx.io/3zb7KHb">YouTube channel</a> for free tutorials and follow <a href="https://dtsx.io/3cn70WJ">DataStax Developers on Twitter</a> for the latest news in our developer community.
<h2>Resources</h2>
<ol>
<li style="font-weight: 400;" aria-level="1"><a href="https://dtsx.io/3vm7J0U">DataStax Astra DB</a></li>
<li style="font-weight: 400;" aria-level="1"><a href="https://dtsx.io/3viVzWI">DataStax APIs: Stargate</a></li>
<li style="font-weight: 400;" aria-level="1"><a href="https://dtsx.io/3zdLUmF">DataStax Web3: Real-time NFT feed</a></li>
</ol>

Blockchain (Data) without the Pain

Eric HallowOnboarding Engineer

Discover more

Share

Share

Building Applications

The Pain of Building in Web3

Difficulty Running Ethereum Nodes

More RPC Calls and Costs

Building with Ethereum Data

Create Astra DB

Load Ethereum Dataset in Astra DB

CQL Query

Connect your Application

Conclusion

Resources

More Technology

Simplifying Agent Development with Astra DB Connector for Vertex AI Search

Making Astra DB easier for MongoDB developers

Empowering Enterprise GenAI: Announcing Luna for RAGStack

Gemini Code Assist + Astra DB: Build Generative AI Apps Faster

One-stop Data API for Production GenAI