Farcaster Devs

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

Syndicate

Solana

A sufficiently decentralized social network. farcaster.xyz

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

hubs

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

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!

Looking for where to start? Try seeing who the most active reply guys are:

https://console.cloud.google.com/bigquery?sq=867429816176:87fef9a0cc334c199363075701d50e74

Also a big shoutout to @pinatacloud for their public Hub support that helps make this possible 🫡 🤝  (https://www.pinata.cloud/farcaster)

Farcaster and IPFS at Scale | https://docs.pinata.cloud/farcaster/farcaster-api

Co-founder @ https://poap.studio, the white glove agency on top of #POAP. Ask for your project there 👉 https://poap.studio

Indexed in real time through our systems and then currently synced to BigQuery every hour!

V2 should hopefully see that BigQuery delay lowered to about 60s