Farcaster Devs

if we die we die (✯◡✯)  彡
 alxstai.com  彡  blockchain tech @dtech & cs @ETHZ  彡  weeb code trapper

Does anyone have full sql dumb of a postgresql synced via shuttle they could share with me?

Readonly psql:// connection string would help to. Hacking with @godsticky.eth

If not how long is the sync process from empty postgres to fully synced?

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

Not exactly shuttle format, but I can get you a read-only postgres connection to something similar if it helps

(same db / format that powers this):

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

Not exactly shuttle format, but I can get you a read-only postgres connection to something similar if it helps

(same db / format that powers this):

https://warpcast.com/runninyeti.eth/0xd02f9bc1

nice! so I could fetch data for say fid 16085 and get a user archive? (see attached claude query for what data i want)

goal is to sync that to the user locally so they own their cast data (playing with electric-sql for sync)

Building /indexing; love your data again. Probably also running 🏃‍♀️

no recursive queries due to a sync engine

Sync engine -> local client -> all queries run against the query showing that data only

sync engine pushes new data from the protocol to the users archive

Hubs ---indexer--> PSQL ---sync engine---> client

Yes! Depending on the use case / user / scale, you could also do that direct in BigQuery (requires connecting to BQ, but scales a bit better for the inevitable recursive queries)