TL;DR: Substreams and ClickHouse revolutionize blockchain data handling, as demonstrated by Pinax co-op students Maryam and Syed in their insightful bulk-loading project. Handling and analyzing vast amounts of blockchain data is a challenge in a rapidly evolving digital landscape. Substreams and ClickHouse are two powerful technologies that promise to revolutionize the way we manage and analyze blockchain data. In this…
substreams
Pull back the curtain and discover how Pinax helped ensure long-term blob storage after EIP-4844. TL;DR: Thanks to quick work from the Pinax team and a flexible, performant software built by StreamingFast, The Graph saved the blobs from centralized doom. The Ethereum Improvement Proposal 4844 (EIP-4844), colloquially known as the “blobs” or “proto-danksharding” proposal, enhances Ethereum’s scalability by enabling temporary…
TL;DR: Mason demonstrates how to use Substreams data to create a dynamic treemap visualization for blockchain balance changes using D3.js and React. Substreams is used to filter and reduce the vast amount of data coming from the blockchain in real time to the data that matters to your application. Let’s follow along as Mason demonstrates how to use Substreams data…
TL;DR: Learn how James got into Substreams and The Graph ecosystem, including his role in BuildersDAO and the improvements he believes this constantly evolving space will bring. James Mulqueeny is a member of the BuildersDAO, and has been working with Substreams for almost a year. We wanted to ask him about his experiences, background, and vision for the future of…
Our story begins with seven passionate people and a shared mission. TL;DR: Discover Pinax’s origin story—how we developed our blockchain data analytics and processing expertise to become a world-class web3 data streaming provider and core devs working on The Graph. Today, Pinax is a web3 data provider with a multi-chain vision. We offer fast and reliable access to blockchain data….
TL;DR: In this recap of IOH #161, you’ll find a rousing edition of Project Watch, covering possible Graph Node developments and the arrival of Sunrise, plus an interactive discussion on the effectiveness of chain integration communications. Opening remarks Hello everyone, and welcome to the latest edition of Indexer Office Hours! Today is June 11, and we’re here for episode 161. GRTiQ 172 Don’t…
Pinax has released Arbitrum One Firehose and Substreams endpoints on the Pinax app, expanding data stream accessibility to one of the leading Ethereum rollups. Anyone with a GitHub account can access the new endpoints from the Pinax app: For those looking to test their contracts, Pinax already provides data feeds for the Arbitrum Sepolia testnet, as well as dozens of…
TL;DR: Thomas Monte is a NYC native and a passionate member of the BuildersDAO. He shares his history with The Graph and his thoughts on new features in the space, e.g. Substreams Triggers. Kevin McGowan (Pinax) met with Thomas Monte from The Graph BuildersDAO to better understand Substreams, and to learn more about why Thomas is so passionate about this…
TL;DR: Introducing Substreams’ new index module! The StreamingFast team joins episode #159 to introduce their latest development, index modules, and how they will result in improvements for indexers. Opening remarks Hello everyone, and welcome to the latest edition of Indexer Office Hours! Today is May 28, and we’re here for episode 159. GRTiQ 170 Don’t miss the GRTiQ Podcast with Joe Vezzani, Co-founder…
Get an insider’s look at AI, SQL, and blockchain tech in The Graph Builders Office Hours #32! TL;DR: Learn about a session of The Graph Builders Office Hours where Sam Green discusses the integration of AI and SQL in blockchain analytics, showcasing Agentc’s capability to enhance data interaction through natural language processing. In episode #32 of The Graph Builders Office…