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?

@horsefacts.eth I assume quikcast was built against the same schema shuttle uses as the types read similar across repos?

I'm eth newbie..just learning
(working on @farcaster)

terminally.online

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

@horsefacts.eth I assume quikcast was built against the same schema shuttle uses as the types read similar across repos?

https://github.com/farcasterxyz/quikcast/blob/main/web/src/lib/database/types.ts

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):

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 🏃‍♀️

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

have you checked roles at bountycaster.xyz ?

Hey Sam, I’m looking for a mobile developer role placement 🙂

I would really appreciate your support