Simplify Real-Time Blockchain Analytics with ClickHouse

Substreams By Dec 05, 2023 3 Comments

TL;DR: ClickHouse Sink revolutionizes blockchain data analytics by offering a fast, flexible, and user-friendly platform for efficient data extraction and processing. Hey there! Let’s dive into the world of blockchain analytics and see how ClickHouse is changing the game. ClickHouse isn’t just any database; it’s a powerhouse for crunching big data in real time. And when it comes to blockchain,…

The Graph Indexer Office Hours #135

TL;DR: The Graph team hosted Indexer Office Hours 135 on November 28, 2023. The meeting covered a variety of topics, including a discussion of the future of indexing, the growth of the Ethereum ecosystem, the importance of decentralization, the challenges of indexing on Arbitrum One, the macroeconomics of indexing, decentralized gateways, the new era roadmap for indexers, and the development of large language models (LLMs). Welcome to…

A Close Look at The Graph’s Technical Advisory Board

The Graph By Nov 27, 2023 1 Comment

TL;DR: The Graph’s Technical Advisory Board (TAB) is set to enhance research and development by providing expert scrutiny for technical plans and Graph Improvement Proposals (GIPs). Hey there! If you’ve been following The Graph, you might have heard about the recent introduction of the Technical Advisory Board (TAB). Wondering what it’s all about? Let’s dive in together. What’s the TAB?…

The Graph Indexer Office Hours #134

Events By Nov 24, 2023 1 Comment

Opening Remarks Welcome to another edition of Indexer Office Hours! Today is November 21, and this is Indexer Office Hours 134. Incredibly, we’ve reached this number already. This is the town square, where ecosystem participants discuss the most important and relevant indexer topics. Repo watch Anna will now give us our regularly scheduled repo watch update. Project watch Protocol watch…

The Graph Indexer Office Hours #133

TL;DR: The Graph protocol is moving to a permissionless system for RPC providers, and the next Agra hard fork will occur on November 28. Opening remarks Welcome to Index Office Hours 133! This is a regular meeting where ecosystem participants come together to discuss the most important and relevant topics for The Graph community. The latest GRTiQ episode features Tegan…

Breaking Down Barriers: Rust for Substreams Developers

Substreams, the brainchild of StreamingFast, is a remarkably robust blockchain data processing engine. It harnesses the capabilities of Firehose to extract blockchain data and empowers developers to write Rust code for processing and storing this data. However, despite the impressive indexing technology that Substreams brings, developers are often hesitant to jump in because they worry about using Rust. In this…

Pinax On Campus with The Graph Foundation: Chengdu University

Events By Nov 16, 2023 No Comments

On October 30, 2023, Pinax participated in The Graph Foundation’s On Campus event at Chengdu University of Information Technology in Sichuan, China. The Graph On Campus aims to educate and empower the next generation of web3 creators by teaching them about web3 technologies, including how to build powerful dApps with The Graph. The schedule currently includes more than 30 campuses…

The Graph’s Next Chapter: A Layperson’s View of a World Of Data Services

The Graph By Nov 14, 2023 1 Comment

Diving into “A World Of Data Services” GIP-0042. Imagine The Graph as a massive digital library. Right now, this library mainly has one kind of digital book called “subgraphs.” But some folks realized that just one type of book isn’t cutting it for everyone’s needs. So, they’re suggesting we add more varieties. Dive deeper and read on to discover how…