TL;DR: In this recap of IOH #171, follow along as indexers share early testing results from applying the account-like flag for performance, what’s coming for indexer-agent, and progress on a subgraph composition feature, plus tips for removing chains from your configuration and managing chain data. Opening remarks Hello everyone, and welcome to episode 171 of Indexer Office Hours! GRTiQ 182…
blockchain indexing
TL;DR: Derek from Data Nexus demos his PostgreSQL setup, including identifying and resolving query performance issues and practical tips for improving query performance. Opening remarks Hello everyone, and welcome to episode 170 of Indexer Office Hours! GRTiQ 181 Catch the GRTiQ Podcast with Danny Zuckerman, co-founder at 3Box Labs, the web3 studio behind Ceramic Network. Ceramic is a decentralized database…
TL;DR: Participants focused on optimizing PostgreSQL databases for performance and scalability, discussing sharding, indexing, monitoring, and diagnosing slow queries, with plans for detailed future workshops. Opening remarks Hello everyone, and welcome to episode 169 of Indexer Office Hours! GRTiQ 180 Catch the GRTiQ Podcast with Aki Balogh, Co-Founder and CEO at DLC.Link, a platform that facilitates trust-minimized Bitcoin smart contracts…
TL;DR: Get all the alpha from Alexandre at StreamingFast as he shares the team’s areas of focus for this quarter: optimizing Substreams onboarding time, increasing the number of Substreams-powered subgraphs, and understanding Substreams user personas. Opening remarks Hello everyone, and welcome to episode 168 of Indexer Office Hours! GRTiQ 179 Catch the GRTiQ Podcast with Goncalo Sa, co-founder and security…
TL;DR: In this recap of IOH #167, learn important considerations for the release of Erigon v3.0.0-alpha1, plus the Linea team answers questions about the chain, which is an EVM-compatible ZK rollup that has recently integrated with The Graph. Opening remarks Hello everyone, and welcome to episode 167 of Indexer Office Hours! GRTiQ 178 Catch the GRTiQ Podcast with John Belizaire,…
TL;DR: In this recap of IOH #166, Matthew from Pinax provides helpful context for important steps to take for the Firehose Ethereum 2.6.5 release. The indexer community shares tools and tips on many topics, including cleaning up old deployments, determining how long a subgraph may take to sync, and scaling up operations to support the growing network. Opening remarks Hello…
TL;DR: In this recap of IOH #165, the discussion was an open session for indexers to share challenges and learn from the group how others are tackling issues. Discover what the future may hold for indexer agent and watch a demo of the allocation wizard in Indexer Tools. Opening remarks Hello everyone, and welcome to episode 165 of Indexer Office Hours!…
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: In this recap of IOH #164, Yaniv Tal, co-founder of The Graph and founder of Geo, joined to discuss Geo, knowledge graphs, and demo Geo Genesis. Learn how the Geo data service will open more opportunities for indexers. Opening remarks Hello everyone, and welcome to episode 164 of Indexer Office Hours! GRTiQ 175 Catch the GRTiQ Podcast with Charlie Hu,…
The Graph, Pinax, and POP Planet hosted the event for devs to share blockchain indexing techniques. On June 23, 2024, The Graph, Pinax, and POP Planet (POPP) co-hosted a private event in Chengdu, Sichuan, China, focusing on technology sharing for web3 developers. Industry professionals, including code engineers and operations staff, were invited. Empowering web3 creators The event aimed to share…