df on Warpcast

Content pfp

https://opensea.io/collection/dev-21

0 reply

0 recast

2 reactions

df pfp

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

14 replies

3 recasts

45 reactions

Bounty Bot pfp

Your bounty deadline just passed (2 week default unless specified). If you'd like to edit the bounty amount or deadline, please update through the bounty frame "admin" button If the bounty was completed, please update through the "admin" button

0 reply

0 recast

0 reaction

Bounty Bot pfp

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

Daniel - Bountycaster pfp

Daniel - Bountycaster

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

HH pfp

Are you already running your own archive node?

1 reply

0 recast

0 reaction

Royal pfp

@nt has, seemingly, had success with indexsupply.com

1 reply

0 recast

5 reactions

Brock pfp

@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

Timur Badretdinov pfp

Timur Badretdinov

goldsky mirror?

0 reply

0 recast

1 reaction

alex pfp

@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 pfp

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

Ryan pfp

0 reply

0 recast

0 reaction

Builder.cook pfp

I'm also a programmer, so here's how you could do it 👇 To efficiently pull IUniswap swap events into your PostgreSQL database for a growing list of token addresses. Fam use a Custom Event Listener Set up a custom event listener with a blockchain API like Alchemy, Infura, or QuickNode to filter relevant swap events from the Uniswap contracts. These APIs allow you to specify contract addresses and event signatures, reducing the amount of data processed. What you need to do first is to 1. Define the event signature (You’ll need to hash it to get the topic) 2. Filter by Token Pairs Use the pair addresses for your specific tokens. You can query these from Uniswap contracts or manually maintain a list. 3. Set Up a Listener Fam you could use ethers.js or web3.js to listen to events for each pair address, any you wish to use. 4. Then lastly Save Data to PostgreSQL Use an ORM like Sequelize or raw SQL queries to insert the events into your PostgreSQL database. Let me know if this works for you.

0 reply

1 recast

1 reaction

Gheorghe pfp

@envio has some examples with hyperindex https://docs.envio.dev/docs/HyperIndex/example-uniswap-v3-multi-chain-indexer

1 reply

0 recast

1 reaction

L3MBDA pfp

maybe throw in some ai and pray for no crashes

0 reply

0 recast

0 reaction

gatedude.eth pfp

Are you looking for pre-filtered high level data?

0 reply

0 recast

0 reaction