@df
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
12 replies
0 recast
22 reactions
@privacywk
Consider using a custom blockchain indexer. Create a service that listens to the Ethereum blockchain, filters only the swap events needed, and writes them directly to your Postgres DB. This tailored approach should optimize performance and manage the high event volume effectively.
0 reply
0 recast
0 reaction