Use this quick overview and easy step-by-step to get started with ClickHouse. TL;DR: For developers new to ClickHouse: learn what it is, why you should care, and how you can use it, including instructions to get started. This is the first article in our analytics developer quickstart series. Are you a developer looking for a database management system that is…
web3 analytics
Your curated news source for web3 and The Graph. The web3 space and blockchain technology evolve rapidly, especially in an ecosystem as complex as The Graph Protocol. Due to a chain-agnostic model, The Graph has touchpoints with many other ecosystems. This makes it even more difficult to keep up with all the latest news and developments. So how can you…
The Substreams-Sink Library is a tool that makes it easy to create sinks in TypeScript to route blockchain data to any destination you need. Whether you need to stream data to a database, a messaging queue, or a text file, the Substreams-Sink Library has you covered. This article will cover how to install Substreams-Sink, its benefits, and how to create…
Unlock powerful analytics with Messari standardized subgraphs. TL;DR: Led by Dylan from Messari, this session provides an in-depth exploration of subgraphs, covering their critical role in data analysis, the tools for building and managing them, and how to contribute to the Messari subgraph repository, emphasizing community and open-source development. Builders Office Hours session #9 was a standout event, featuring Dylan…
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…
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…
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…