$GRT
On March 15, 2024, The Graph and Pinax hosted an event focused on web3 data indexing technology at Sichuan University in Chengdu, Sichuan, China, held on the Jiang Campus.
The Graph On Campus event aims to teach the next generation of web3 creators about web3 technology by sharing lessons on how to build powerful dApps using The Graph.

Event Review
The event was hosted by Pinax Asia team member Eleven, and speakers included Le Sheng from The Graph, Lena from Pinax, and Liu Hong from Sichuan University’s Digital Intelligence and Computational Arts Laboratory (DICN).

$GRT
#区块链开发 #区块链数据索引 #质押挖坑
TL;DR: Hear from delegator Josh as he talks about his delegation journey on The Graph and the parameters he uses when evaluating which indexers to delegate to.
Opening remarks
Hello everyone, and welcome to the latest edition of Indexer Office Hours! April 2, Issue 151
GRTiQ 162
Listen to the latest GRTiQ podcast with Red Sheehan, Protocol Research Analyst at Messari.
Content Review
Latest updates to important repositories
Execution Layer Client
Erigon v2.0 new product release:
v2.59.3 version:
This release sets the Naples hard fork at block#5423600on the Amoy testnet.

$GRT
In 2024, Pinax plans to support new chains of network integration, enrich new data services, facilitate the development of decentralized data, and provide educational resources for web3 builders.
Pinax is preparing for an ambitious 2024. Our goal is to enhance The Graph and the web3 developer ecosystem through innovation and support.
What is our mission? To accelerate growth, simplify development, and enhance learning.
Learn about our plans:
Support for new chains integrated with The Graph Network.
Launch new and advanced data services.
Support for the sunrise of decentralized data on The Graph.

$GRT
GraphOps showcased GraphSeer, an application with on-chain and off-chain data, covering indexing performance and protocol metrics, while Edge & Node discussed the completion of Sunray, the first phase of the decentralized data Sunrise.
opening remarks
Hello everyone, and welcome to the latest edition of Indexer Office Hours! March 26, Session 150.
Video link: https://youtu.be/wkgGPRErDlE
GRTiQ 161
Listen to this week’s GRTiQ Podcast featuring Kirsten Pomales, co-founder of TalentLayer, an innovative open protocol and developer toolkit revolutionizing the services market.

$GRT
A developer from BuildersDAO shared insights on Substreams composability, including his demonstration of Chainlink Substreams integration.
Learn more about Graph BuildersDAO and watch member Thomas demonstrate insights into the composability of Substreams.
Graph Builders meeting times
Without Graph BuildersDAO, there would be no Builders online office hours.
What is BuildersDAO?
BuildersDAO is a developer organization dedicated to building subgraphs and subflows. The DAO acts as a hub for new and existing protocols where the creation of subgraphs or subflows can be requested.

$GRT $ARB
#热门话题 #区块链数据 #区块链开发 #数据索引
This session's fireside chat with principal PaulieB provided great insights for indexers.
opening remarks
Hello everyone, and welcome to the latest edition of Indexer Office Hours! March 19, Game 149.

Video link: https://youtu.be/UvcHh9Oh_qI
GRTiQ 160
Listen to the latest GRTiQ podcast with Daniel Keyes, co-founder and CEO of Pinax. Learn about his early career in broadcast journalism, followed by a decade in banking. Explore his journey into the world of crypto, his transition to a full-time job in web3, and the origins of Pinax.

$GRT
TL;DR: The Graph’s Technical Advisory Board (TAB) has been officially formed. Six members will review and assist with the development of The Graph. Learn more about these six outstanding individuals.
The Graph Council recently appointed founding members of the Technical Advisory Board to help shape the future of The Graph.
Our previous article, A Closer Look at The Graph’s Technical Advisory Board, profiled all the applicants. Now that the selection process is complete, we would like to introduce you to the six initial members.
TAB’s role and vision

Indexer Office Hours#148provides a GraphOps update to Subgraph Radio and deploys a subgraph for indexing historical blobs from Pinax.
opening remarks
Hello everyone, welcome to the latest edition of The Graph Indexer online conference! Game 148.

Video link: https://youtu.be/M4_ufQRo9oE
Join this week’s GRTiQ Podcast with Baki Er, co-founder of Clave, an innovative new wallet that’s garnering attention for its novel approach to enhancing the crypto wallet user experience. (For related links, click "Read the original text" in the lower left corner)

Use this quick overview and simple step-by-step procedures to get started with ClickHouse!
TL;DR: For developers new to ClickHouse: Learn what it is, why you should care about it, and how to use it, including getting started. This is the first article in our developer quickstart series.
Are you a developer looking for a database management system optimized for high-performance analytical queries?
ClickHouse can be your first choice! This open source SQL database management feature is powerful, enabling lightning-fast queries on large data sets, delivering answers in milliseconds, not minutes.

Semiotic Labs joins IOH#147to provide an overview of the Timeline Aggregation Protocol (TAP) indexer experience, as well as additional updates on what the team is working on.
opening remarks
Hello everyone, and welcome to the latest edition of Indexer Office Hours! March 5, Issue 147.

Video link: https://youtu.be/NwovWSPB4tI
Don’t miss the latest episode of the GRTiQ Podcast with Chris Were, CEO and co-founder of Verida, a team dedicated to hyper-personalization where user data is used privately and voluntarily to create new products and services.

The biggest highlight for 2023 is Launchpad V2, with improved modularity and more features. Learn more about 2023 goal progress, community development, challenges, and plans for 2024. The final Launchpad virtual session of 2023 is a special edition that includes a year-end review. Read on to learn about 2023 achievements and progress, including the transition to Launchpad V2. 🗣 Launchpad Office Hours (LOH) are bi-weekly meetings hosted by the GraphOps team where indexers learn and ask questions about the latest updates running Launchpad. What is Launchpad? Launchpad is a toolkit for running Graph protocol indexers on Kubernetes. Kubernetes is a powerful container orchestration platform that simplifies application management and scalability. It features load balancing and declarative configuration capabilities that increase efficiency, making it easier to deploy and manage applications across various cloud environments. Kubernetes is helpful for indexers, not just for indexing, but also because it adds core services like RPC endpoints and monitoring. 2023 Highlights: The Evolution of Launchpad The biggest achievement of 2023 is the transition from Launchpad V1 to V2. The first version lacked some features, wasn't very customizable, and wasn't accessible to everyone. The second version is more modular and has more features, making it more practical. The image below helps visualize the differences between the two versions. 🚀V1 and V2 Astronauts, as shown in Launchpad Online Session#9What changes from Launchpad V1 to V2? A summary of the 2023 goals as presented in Launchpad Online Session #9: Reduce the time from upstream release to availability in Launchpad in a consistent manner. Lately, this has been smooth and sustainable. Ideally, the GraphOps team would like to push automation even further with comprehensive automated tests that are sufficient for release without human intervention. Goal: Produce high-quality documentation and keep it up-to-date. Setting up the generated documentation for the namespace was a lot of work, but it worked. Documentation needs to be updated in an automated manner, which results in higher upfront development costs. The team has produced a few guides, but they don't cover as much as they would like (i.e. CoreOS).Goal: Pursue a development model to test Launchpad on our own infrastructure. The GraphOps team has been rigorous in achieving this goal. The Nethermind and Heimdall charts do not see stable releases, only canaries, as these chains are not yet running on Launchpad V2 infrastructure. The team is excited that their examples are helping to drive Launchpad development, enforcing minimal testing and usage. They encourage the larger community to share examples and challenges, or open bug reports. Goal: Achieve greater modularity and flexibility. The GraphOps team introduced scalingInterfaces to allow control over workload management. The real power of scalingInterfaces is the ability to automatically scale workloads based on a specified replica count and update all endpoints and values ​​without manual intervention. The team added the ability to override chartVersion and chartUrl as requested by the community. This is particularly useful if the default namespace settings do not meet the user's specific requirements. This allows the flexibility to specify versions and URLs that best suit individual needs while still getting the benefits of namespaces. 2023 Community Growth and Engagement Statistics The team hosted 9 LOH sessions LOH recording on YouTube had 200+ views Graph The community has given 300+ likes to LOH related tweets 40+ people joined us on Discord Live Meeting Challenges and Lessons Learned New updates to the blockchain must be made carefully to maintain network integrity and avoid data corruption. Implementing and managing various blockchain consensus mechanisms in a Kubernetes cluster requires a thorough understanding of both technologies, which can be a barrier to using Launchpad. The Road Ahead Adds Firehose and Substreams Support for making the architecture available (as previously previewed) Re-adding Celo and Polygon and introducing Optimism Support for improved documentation, FCOS guide Better key management Improved observability layer (more dashboards, Alert Rules) Introduce some data backup/move functionality (or at least document a solution here) Join LOH for more information If you are interested in running the latest updates from Launchpad, please join us every other Wednesday at 5 PM UTC Discord.For more content, follow the public account: Pinax

Learn the basics of Substreams, a powerful blockchain data indexing solution. TL;DR: For those new to Substreams, learn what it is and how it makes blockchain data more accessible to developers. Are you looking for the best blockchain data indexing solution? Wondering how to effectively extract and manage blockchain data? Get started with Substreams! This is the first in a series of articles that will take you from Substreams newbie to master. Problems Accessing Blockchain Data Developers often find it challenging to build data-centric applications, especially when faced with blockchain data. Extracting blockchain data is difficult and complex, and due to the linear and distributed nature of blockchain, extracting data in a fast and reliable manner is even more challenging. Substreaming is the solution There aren’t many solutions out there to solve this problem, but StreamingFast , experts in building blockchain data processing tools, are stepping up. They are using a new technology called Substreams to make it easier to process and index blockchain data quickly and reliably. Let’s take a look at what Substreams are and how they make blockchain data more accessible. What is a substream? Substreams is a powerful blockchain data indexing technology built and developed by StreamingFast for The Graph Network. It enables developers to extract data from the blockchain, apply custom transformations to meet the unique needs of their applications, and effortlessly direct processed data to a variety of destinations such as PostgresSQL, ClickHouse, MongoDB, and more wait. How do substreams work? Substreams involves two main components: Substreams providers and Substreams packages. Let’s take a closer look at each one: Substream providers: Substreams providers store and deliver blockchain data. These providers, like Pinax, use Firehose, a high-performance blockchain-agnostic data extraction engine developed by StreamingFast, to efficiently ingest blockchain data. Substreams package: The Substreams package is a small Rust program compiled into WebAssembly that defines the transformations the developer wants to apply to the data.Developers use gRPC requests to send Substreams packages to a Substreams provider, which then executes the request and streams back the transformed data. Additionally, developers can send data to other destinations as needed. Currently, Substreams can only be built using Rust, but the StreamingFast team plans to let developers build Substreams in Golang and TypeScript in the near future. Three Ways to Use Substreams Developers have different options when working with substreams: They can use pre-built substreams or build their own: Using Substreams: The easiest way to leverage Substreams is to use the ones available on the Substreams Registry With pre-built Substreams packages, the Substreams Registry is your one-stop destination for discovering and sharing Substreams packages. You can choose a package that meets your needs and seamlessly stream data to your preferred destination. Building a substream: If you can't find a suitable Substreams package in the Substreams registry, you can create your own. After development, these packages can be published to the registry to make them available to others. Extending substreams: You can also leverage existing Substreams modules in the registry and build new Substreams modules on top of them, resulting in entirely new datasets. This approach allows subflow functionality to be customized and extended to meet specific requirements. This collaborative approach promotes a vibrant ecosystem where developers can contribute their solutions and benefit from the collective knowledge and innovation within the community. Benefits of Using Substreams Substreams provide developers with many advantages when indexing and querying blockchain data. Here are some of them: Speed: Substreams prioritizes speed through a parallel architecture and stream-first design, ensuring efficient blockchain data indexing. Composability: Subflows provide composability, allowing developers to easily use each other's code or modules to create complex indexing pipelines. Reusable: Substreams emphasizes reusability, enabling you to perform its indexing tasks using pre-built substreams available on the Substreams registry. Custom sinks: Substreams supports custom sinks, allowing seamless integration with your preferred data storage or analytics solution.Move blockchain data indexing to a provider: Substreams allows you to offload the heavy lifting of blockchain indexing to a service provider like Pinax. Providers can scale based on requests and sink data into various databases, alleviating the need to run expensive inodes themselves. Strong community support: Despite being a new technology, Substreams has attracted a lot of attention from developers, and the number is growing steadily. At Pinax, in addition to the StreamingFast Discord community, we have another Discord community that can provide you with support and assistance if you want to use the Substreams technology solution. To learn and explore more blockchain data indexing technology, follow the WeChat public account: Pinax