Ponder

A tool for indexing and querying blockchain data.

Ponder is a TypeScript framework for indexing blockchain data into PostgreSQL, providing a structured approach to processing on-chain events.

It offers type-safe database interfaces, built-in caching and syncing capabilities, and optimized query performance for blockchain applications.

Experience:

Set up Ponder indexing service with PostgreSQL for Opyn chain data on Arbitrum Testnet, enabling efficient data retrieval.

Implemented Ponder in BasilicEVM as the standard data layer solution, creating a seamless developer experience for blockchain data.

Designed transaction data indexing systems with Ponder for real-time analytics and historical querying in DeFi applications.

Created custom event processors to transform blockchain data into structured database records for efficient application queries.

Developed GraphQL and REST API layers on top of Ponder-indexed data to provide consistent interfaces for frontend applications.

Opyn

Opyn is a decentralized options protocol on Arbitrum that raised $6.7M Series A funding led by Paradigm. Their main product Squeeth is a notable DeFi-native derivative. I implemented their initial trading interface and data indexing setup for Arbitrum Testnet using Next.js, Ponder, and viem/wagmi.