Content
@
https://warpcast.com/~/channel/fc-devs
0 reply
0 recast
0 reaction
Brock
@runninyeti.eth
Want all of Farcaster free and queryable? Tired of trying to run replicators? We've got a BigQuery dataset for you 😉 https://console.cloud.google.com/bigquery?project=glossy-odyssey-366820&ws=!1m4!1m3!3m2!1sglossy-odyssey-366820!2sfarcaster
8 replies
10 recasts
40 reactions
Brock
@runninyeti.eth
This dataset is a free, public good and a labor of love from us at indexing.co We're committed to the @farcaster ecosystem 💜 Farcaster is now a first-class citizen for our indexing pipelines right alongside chains like /basese, /syndicate, and /solana Permissionless data == limitless opportunities
3 replies
1 recast
11 reactions
Brock
@runninyeti.eth
Looking for where to start? Try seeing who the most active reply guys are: https://console.cloud.google.com/bigquery?sq=867429816176:87fef9a0cc334c199363075701d50e74
1 reply
0 recast
3 reactions
Brock
@runninyeti.eth
Our approach with this dataset is simple: Normalize /hubs events to make data easier to work with. We would *love* feedback to make this as useful for the world as possible To start, we have 5 tables available: casts, links, reactions, verifications, and profiles
3 replies
0 recast
4 reactions
Brock
@runninyeti.eth
Currently, BigQuery is updated every hour with the latest snapshot of data. Depending on feedback, we'll likely try to make this truly realtime using some materialized views (any BigQuery experts out there?) Need realtime data now? Just reach out - we can transform and pipe realtime data to your database(s) as well!
1 reply
0 recast
2 reactions
vrypan |--o--|
@vrypan.eth
I don't see the signer, is it there? The signer is a very important piece of info because it lets you identify the app used to create a message.
2 replies
0 recast
0 reaction
stringtheory
@stringtheory69
Hi - this is awesome - thanks! I'm not too familiar with BigQuery - could you help me figure out how to query casts by likes, quotes, reposts?
1 reply
0 recast
0 reaction
