Content
@
https://warpcast.com/~/channel/fc-devs
0 reply
0 recast
0 reaction
Stephan
@stephancill
i need a cheap API that can tell me all the mutuals of a given fid - dune query too expensive - neynar API no longer works building this requires an index of the whole follow graph and needs to be kept in sync
12 replies
1 recast
32 reactions
Kasra Rahjerdi
@jc4p
if you’re fine with data being 2-3 weeks old you can do this with my huggingface data dumps
1 reply
0 recast
1 reaction
Stephan
@stephancill
how easy is it to query?
1 reply
0 recast
0 reaction
Kasra Rahjerdi
@jc4p
it’s duckdb so everything you’d be used to
1 reply
0 recast
1 reaction
Stephan
@stephancill
can i query it via api or do i need to download?
1 reply
0 recast
1 reaction
Kasra Rahjerdi
@jc4p
you need to download the full parquet file unfortunately and spin up a tiny server to run the sql for you on demand
1 reply
0 recast
1 reaction
Kasra Rahjerdi
@jc4p
me trying to figure this out in real time cause i need it to: long story short fuck the parquet files, use Snapchain HTTP API (thru Neynar or your own API) but watch out the Snapchain http docs are like "haha!" level bad -- this approach is 2 API calls so no server needed
2 replies
0 recast
1 reaction
vrypan |--o--|
@vrypan.eth
I used to treat queries to hubble/snapchain as an expensive resource. But a local snapchain instance is quite an efficient and fast db (if it can answer what you want). It is build to answer these queries.
1 reply
0 recast
1 reaction
Stephan
@stephancill
I wish I could download a snapshot for a set of fids that I care about
0 reply
0 recast
0 reaction
