Content
@
0 reply
0 recast
2 reactions
df
@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
10 replies
26 recasts
100 reactions
Royal
@royalaid.eth
@nt has, seemingly, had success with indexsupply.com
1 reply
0 recast
7 reactions
HH
@hamud
Are you already running your own archive node?
1 reply
0 recast
0 reaction
Timur Badretdinov
@destiner.eth
goldsky mirror?
0 reply
0 recast
1 reaction
alex
@alexgrover.eth
We’ve done this with Ponder successfully. We emitted the Uni pool address from our factory, not sure if you’d be able to do that in your setup
0 reply
0 recast
1 reaction
Stephan
@stephancill
Assuming this is for getting prices you essentially need to read the price for every token on every block You can make this more efficient by only looking up the prices that have changed in a block If this is just for the Larry UI and not for realtime analytics then you can have a price api that caches requests for a few seconds
0 reply
0 recast
1 reaction
Daniel - Bountycaster
@pirosb3
Is latency / realtime a requirement? Or is it okay if you have a delay of 5-10 minutes? In any case, consider working with a data provider. Allium and Goldsky provide what you are asking for as a service, check them out
1 reply
0 recast
0 reaction
Bounty Bot (BETA TESTING)
@bountybot
Confirmed! On your bounty page, you can pay users and view their bounty completion history Frame buttons - Admin: manage bounty status (in progress, complete), edit amount and deadline - Boost: get more attention on your bounty 🤖 commands - @bountybot cancel - @bountybot in progress - @bountybot complete (optional: tag winners) - @bountybot shoutout (optional: tag winner and write a positive review)
0 reply
0 recast
0 reaction
Brock
@runninyeti.eth
Quick transformer for decoding V2/V3 swaps simultaneously (this looks at pool events, could also go by token transfers): https://console.indexing.co/flow/675ebd65085be53512a3a323 There's no limit on number of chains nor addresses being watched. And it can all be piped to any db, webhook, etc. There are also APIs to dynamically handle adding / removing watched addresses. Standard pricing is $1 per 1000 blocks *processed* - blocks without matching events won't count --> likely in the $10-100/m range at this point for this use case (and yes, $LARRY would be accepted). dm me if you're interested!
0 reply
1 recast
3 reactions
Gheorghe
@gheorghe
@envio has some examples with hyperindex https://docs.envio.dev/docs/HyperIndex/example-uniswap-v3-multi-chain-indexer
1 reply
0 recast
1 reaction
gatedude.eth
@gatedude
Are you looking for pre-filtered high level data?
0 reply
0 recast
0 reaction
