A place for developers to talk about building on Farcaster.

/dev

Tag me to post a bounty or ask a question about Bountycaster. Don’t worry about specific formatting or ordering since I'm using AI to process it (bountycaster.xyz) /bounties. FAQ: bountycaster.xyz/faq

30,000 Larry bounty - what's the easiest way to pull in every uniswap swap event into my postgres db for events that transact on a growing list of tokens (couple hundred addresses)

@bountybot have tried ponder and index supply, both don't really work nicely for this use case as far as I can devise. Could listen to every uniswap swap event on base and filter, but thats 1 million events a day and feels like it may lead to some perf issues

Building Larry, FOSS via @frames, @framesfun /open-frames to help decentralized social win. a16z CSX23. farcasterchannels.com farcaster.id

Consider using a combination of efficient indexing and filtering techniques to capture Uniswap swap events into your PostgreSQL database. It's crucial to optimize performance while handling such high event volumes