ENS Stalker Site

The biggest challenge I sought to solve was figuring out the right way to query and cache Dune analytical information in a way that's computationally efficient.

I decided to cache the execution ids and query ids using Redis, and running the queries statelessly against this Flask webapp I've built.

Flask webapp, Dune API Key, and Redis cache

I used the Dune API key and a base query build on the website to do a reverse ens lookup query! I'm starting off just providing basic information like last_tx_id and eth address, but these are the primitives for a lot of other downstream applications, like wallet labeling or other deeper analytics.

Eventually I will support any query on and ENS and will catch query and execution ids in flight.