We’re excited to announce the launch of our new and improved Pinax app, a web-based platform that helps you easily manage your Pinax Firehose and Substreams services. Whether you’re an indexer, a developer, or a curious explorer, the new app will help you get the most out of our services. If you’ve been using the old app, which is no…
substreams
TL;DR: ClickHouse Sink revolutionizes blockchain data analytics by offering a fast, flexible, and user-friendly platform for efficient data extraction and processing. Hey there! Let’s dive into the world of blockchain analytics and see how ClickHouse is changing the game. ClickHouse isn’t just any database; it’s a powerhouse for crunching big data in real-time. And when it comes to blockchain, that’s…
Pinax is launching community support for developers!
We’re very excited to announce a major addition to the developer experience at Pinax: our brand-new Pinax Community Discord Server 🥳!
Opening Remarks Welcome to another edition of Indexer Office Hours! Today is November 21, and this is Indexer Office Hours 134. Incredibly, we’ve reached this number already. This is the town square, where ecosystem participants discuss the most important and relevant indexer topics. Repo watch Anna will now give us our regularly scheduled repo watch update. Project watch Protocol watch…
Diving into “A World Of Data Services” GIP-0042. Imagine The Graph as a massive digital library. Right now, this library mainly has one kind of digital book called “subgraphs.” But some folks realized that just one type of book isn’t cutting it for everyone’s needs. So, they’re suggesting we add more varieties. Dive deeper and read on to discover how…
Hey there, fellow developers and builders! We’ve got something exciting to share with you. Ever heard of Substreams? If you’re into blockchain, this is something you’ll want to know about. Let’s dive in. Graph Builders Office Hours mission The Graph Builders Office Hours aims to empower developers and teams working with The Graph protocol by focusing on the technical aspects…
Reliable access to blockchain data in seconds, at blazing fast speeds. Pinax is excited to announce that our free service is available, providing you with the APIs to use Firehose and Substreams for supported blockchains. Want to jump right in and try the service? Skip to the steps to get started right away. What are Firehose and Substreams? Firehose is…
Discover how DappLooker leverages Substreams to deliver real-time data for their web3 analytics. Ever wondered how DappLooker, a leading no-code analytics platform, manages to provide real-time data? The answer lies in the magic of Substreams. This video provides a dive deep into how DappLooker uses Substreams to revolutionize web3 analytics. The journey of DappLooker DappLooker uses Substreams in their approach…
Learn how Spyglass is building a cutting-edge web3 analytics platform to tackle the issues of complexity and slow access to blockchain data by harnessing the power of Substreams. The challenges of web3 analytics Web3 analytics have always been complex and time-consuming, involving hours of crafting extensive SQL queries on platforms like Dune Analytics. Another challenge is the delay in data…
Stop wasting time looking for block numbers on block explorers. Instead, use Pinax’s new Block Time service. Follow along with Étienne, an analytics developer at Pinax, as he showcases Block Time, a revolutionary service that allows you to retrieve data using specific dates rather than block numbers. Thanks to Substreams technology, you can get the information you need from the…