Discover how we’re building our datasets for exceptional efficiency, ease of use, and performance. TL;DR: Pinax’s datasets simplify blockchain data access using Parquet files and S3. This combination provides efficient storage, accelerated query performance, and seamless integration with various analytics tools. Raw blockchain data is structured using SQL schema, making it readily available for analysis. Our datasets offer a user-friendly…
Paul Barba
I am a dedicated member of the Graph Advocates DAO and proud to be a part of the Graphtronauts community. As a passionate crypto investor and enthusiast, I have delved into the world of decentralized technologies, with a strong focus on The Graph protocol. My journey includes writing insightful blogs for Graphtronauts and contributing to the development of subgraph documentation for various projects within The Graph ecosystem. Most recently, I have taken on the role of a Pinax technical writer, further expanding my commitment to advancing the adoption and understanding of blockchain and Graph-based technologies. /n https://twitter.com/PaulBarba12 https://github.com/PaulieB14 https://hey.xyz/u/paulieb https://medium.com/@paulieb.eth/about
TL;DR: An inspector in The Graph ecosystem discovered and reported an indexer submitting incorrect Proof of Indexing (POI) for unsynced subgraphs. The arbitration process resulted in a slashing penalty for the disputed indexer. This case highlights the crucial role of vigilant community members in maintaining the reliability and fairness of The Graph Network. Imagine uncovering faulty behavior in a decentralized…
Explore updates on Substreams tools, Graph Horizon, and the Subgraph Service. TL;DR: Core Dev Call #31 highlighted three key updates for The Graph: – Substreams Codegen: New tools to simplify Substreams-powered subgraph development. – Graph Horizon (GIP-0066): A modular protocol for diverse data services. – Subgraph Service (GIP-0068): Major improvements to subgraph indexing. Core Dev Calls are meetings where core…
Devs! Learn how to set up this ERC20 Token API—it’s free and open source. TL;DR: Pinax’s open-source ERC20 Token API offers developers an easy, customizable way to access real-time and historical token data, like balances, holders, and transfers, across EVM and Antelope chains. Have you ever needed to fetch comprehensive ERC20 token data for your blockchain application? Pinax has solved…
The Graph Builders Office Hours #50 featured a subgraph showcase highlighting new and upcoming features. TL;DR: Learn about the latest advancements in subgraph technology, including timeseries aggregations, indexed argument filtering, and parallelized ETH calls, while also discussing the future potential of modular, reusable subgraphs and improvements to IPFS robustness within The Graph ecosystem. The Graph ecosystem is evolving rapidly, offering…
TL;DR: Pinax datasets simplify accessing blockchain data, making it easy for analysts to focus on analysis without needing specialized tools. Accessing blockchain data for analysis is complex, especially for analysts without specialized blockchain data extraction knowledge, but demand in this space is growing. Pinax will soon offer datasets that make it effortless for anyone to access blockchain data for analysis…
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: 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: 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…