TL;DR: This week, indexers share what they’d like to cover in upcoming educational sessions on Kubernetes, plus Semiotic Labs shares an update on Timeline Aggregation Protocol, which is ready for testing on testnet and will be deployed to mainnet soon. Opening remarks Hello everyone, and welcome to episode 174 of Indexer Office Hours! GRTiQ 185 Catch the GRTiQ Podcast with…
Pinax Team
We're a web3 service provider specializing in blockchain indexing operations. Our mission is to enable creators to achieve their true potential with web3 technology. We want to help developers reliably access blockchain data in a consistent format so you can create amazing experiences for your applications.
Pinax helped The Graph engage with conference participants and promote the power of the protocol. On August 16–18, 2024, ETH Shenzhen gathered web3 developers, enthusiasts, and cutting-edge project teams to explore the future of the Ethereum ecosystem. The event was co-hosted by OpenBuild (@OpenBuildxyz), the Shenzhen University Blockchain Association, and Panta Rhei (@0xpantarhei). ETH Shenzhen aimed to connect, inspire, and…
TL;DR: In this week’s Indexer Office Hours, special guest John Graber, Principal DBA at Edge & Node, returns to answer more indexer questions about PostgreSQL. The session covers index design for optimal performance, optimizing PostgreSQL on NVMe, sharding frameworks, key monitoring metrics, and more. Opening remarks Hello everyone, and welcome to episode 173 of Indexer Office Hours! GRTiQ 184 Catch…
If you’re new to The Graph and not a developer, this overview is for you. TL;DR: Curious about The Graph but not sure who to ask? This post will teach anyone—especially non-technical people—about The Graph, what it does, who operates the network, and why it’s important. This post is your chance to learn about The Graph at a basic level….
TL;DR: In this week’s recap of Indexer Office Hours, special guest John Graber joins to answer indexer questions about PostgreSQL. This session is loaded with insights on best practices for configuration tuning, database optimization, third-party monitoring tools and so much more. Opening remarks Hello everyone, and welcome to episode 172 of Indexer Office Hours! GRTiQ 183 Catch the GRTiQ Podcast…
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…
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: 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…