Farcaster

hello farcaster friends

i'm working on improving my sql and i thought it would be fun to practice with real data and answer real questions about the network we're all on 

so, if you've ever wondered something about the farcaster network and the data on it - shoot

examples of questions that i can answer with a sql query:
> what's the daily avg # of casts?
> what % of casts are just text?
> who has been the most mentioned user this week? 

(will answer as many as i can over the next couple of days!)

personality hire 🌈🤙 fullstack & ux design, building /uno

Trying to remember if I had a nasty self join in my back pocket

Building Higher apparel at High Line 🧢 
Host at /clickcast /cpg || Husband to @shiwen

i saw your q - i don't have access to session data, i'm just using what is written to the hubs!

Got it, what granularity then? I’ve not looked at the hub data to know

user data like username, display name, bio, follower/following count 

engagement data such as likes, recasts, quote casts, replies

also have access to cast content such as the text, and what embeds are included (images, urls, videos, frames)