Farcaster Devs

what is the fastest way to get all the links for a list of fids assuming i have direct access to a hub (and potentially the rocks db)?

- the hub rest api is slow and can only do a max pageSize of 1000, but is reliable
- grpc is much faster (no page size limit) but starts falling over when you blast it with requests

i'm considering trying to read directly from rocksdb at this stage

any ideas?

SQLQuery against rocks db sounds solid + adaptable though be aware looking for all links you need to check for link delete aka unfollow messages too if you want to get the current state of what the FID intended

Farcaster Development Boutique @ https://dTech.vision 💜 in love with tech 🤓decentralization, fitness and oldschool rap 😎