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

random facts and life excerpts. vulnerability is strength ✨🌈 fullstack & design, building /uno

What is the longest palindrome anyone has casted?

Who has the longest streak of days alternating casting and not casting?

Which two users have the most similar following activity, defined as the longest matching sequences of the order in which they follow other users?

Trying to give you some escalating difficulty here :)

Head of Engineering at Courtyard.io, bringing physical collectibles onchain. nf.td/joe /courtyard /backend

For the last one, if user A follows C then D then E and user B follows D then E then C they have a matching sequence of 2.

last one is a good challenge for @andywon.eth