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…
Together, AI and blockchain have the potential to create an inclusive and secure internet where everyone counts. TL;DR: Explore the intersection of AI and blockchain, the need for decentralized AI solutions, and the benefits of combining AI and blockchain. The internet has evolved, but centralized control remains common. AI and blockchain offer transformative potential to address this issue, paving the…
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: Learn about the features of Subgraph Studio and how it can help you build, test, deploy, and publish your subgraphs to The Graph Network. The Graph is essential for creating decentralized applications (dApps) in the web3 ecosystem. It allows developers to query data from different blockchains and present it in a user-friendly way. This article focuses on The Graph’s…
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: Find out how Semiotic Labs plans to integrate AI with The Graph, leveraging its decentralized and transparent blockchain data for more accurate and efficient results. In a recent episode of Builders Office Hours, Marcus from Edge & Node hosted Sam Green and Anirudh Patel from Semiotic Labs to discuss their work on integrating AI with The Graph protocol. Here’s…
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: 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…
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!…