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 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…
Easily build fast, efficient, and responsive Antelope applications using Substreams. TL;DR: Foundational modules make Substreams easy. Get streaming Antelope data from Pinax. Then put it in your favorite database using purpose-built Substreams sinks from Pinax. Pinax has released new foundational Substreams modules for Antelope blockchains like EOS and WAX. These modules allow Antelope developers to stream blockchain event data using…
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: 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…