One post tagged with "indexing"

Every dApp I've ever worked on eventually hits the same wall: reading data back out of the blockchain. Writing to a contract is the easy, glamorous part. Then someone asks for a page that shows "all the user's past transactions, sorted by date, with token metadata," and you remember that the chain is a terrible database. You can't just SELECT * FROM transfers. You have to index — replay events, shape them into tables, and keep them in sync as new blocks arrive. For years the default answer to that was a subgraph on The Graph. Ponder is a bet that there's a much nicer way to do it, and after spending time with it, I think the bet mostly pays off.