Brock pfp

Brock

@runninyeti.eth

416 Following
663 Followers


Brock pfp
Brock
@runninyeti.eth
You just need to find all the sub-plots - those are fun sprints
0 reply
0 recast
0 reaction

Brock pfp
Brock
@runninyeti.eth
Don't ask questions you don't want the answer to
0 reply
0 recast
1 reaction

Brock pfp
Brock
@runninyeti.eth
Now is clearly the perfect time. The only better time was 1 hour ago
1 reply
0 recast
1 reaction

Brock pfp
Brock
@runninyeti.eth
20 $CSV
1 reply
0 recast
1 reaction

Brock pfp
Brock
@runninyeti.eth
I don't like this
0 reply
0 recast
2 reactions

Brock pfp
Brock
@runninyeti.eth
Inverse @bountybot πŸ€”
0 reply
0 recast
1 reaction

Chase Sommer pfp
Chase Sommer
@chasesommer.eth
Let me know if you have Farcaster Bot dev friends :)
2 replies
1 recast
2 reactions

Brock pfp
Brock
@runninyeti.eth
<live view of @aperture at work>
0 reply
0 recast
2 reactions

Brock pfp
Brock
@runninyeti.eth
In this specific case, that's what I'm trying to think through too πŸ€” At a Farcaster protocol level, there is no notion of "language", just "text". So we'd need to come up with some way to detect language via SQL (or using fancy functions like that `ML.TRANSLATE` that Google offers)
1 reply
0 recast
1 reaction

Brock pfp
Brock
@runninyeti.eth
Very cool πŸ‘€ Sounds like the biggest trick here would be figuring out how to identify non-English alphabets inside the `casts.text` field - maybeee something like this? https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-translate
1 reply
0 recast
1 reaction

Brock pfp
Brock
@runninyeti.eth
gm gm! We have this public BigQuery dataset that can probably help: https://warpcast.com/runninyeti.eth/0xd02f9bc1 Do you have any thoughts on how to define "non-native English speakers"? If so, we can probably help construct the query with you!
1 reply
0 recast
0 reaction

Brock pfp
Brock
@runninyeti.eth
Let us know if you need any help!
1 reply
0 recast
2 reactions

Brock pfp
Brock
@runninyeti.eth
12D3KooWFEszQLFwayEVXy49vkEY5hxandgjPjqy1HfnkQpFTCQG /indexing
0 reply
0 recast
0 reaction

Brock pfp
Brock
@runninyeti.eth
- Not always clear what "healthy" is (e.g. am I fullyyy in sync?) - Would love more configuration options (e.g. keep events longer, parallelize initial sync, change dir for storage) - Is gRPC still supported? - Direct access to underlying db - Clustering support (2+ hubs explicitly staying in sync with each other)
1 reply
1 recast
2 reactions

Geoff Golberg pfp
Geoff Golberg
@geoffgolberg
If anyone is interested in having their social graph visualized.. trying something out here.. For $350 here's what you'll get: - Output will resemble FarCon graphic (mint it as an NFT if you'd like!) https://warpcast.com/geoffgolberg/0xee3cbbea - 30 minute discussion with me to answer any questions you may have
5 replies
2 recasts
11 reactions

Brock pfp
Brock
@runninyeti.eth
Conversely, I just unfollowed @geoffgolberg and that same endpoint no longer returns a link for 194479 following 4528 (at least on hubs that have the message synced already; including the ones powering /supercast)
0 reply
0 recast
2 reactions

Brock pfp
Brock
@runninyeti.eth
I think the important part here is: "You can query the getLinksByFid or getLinksByTarget and that will return the full set of all valid LinkAdd messages" ^ that query is returning a LinkAdd message for fid 3 (dwr.eth) following fid 4528 (geoffgoldberg)
1 reply
0 recast
2 reactions

Brock pfp
Brock
@runninyeti.eth
Ahh yeah latency amongst providers is definitely a thing πŸ˜…
0 reply
0 recast
0 reaction

Brock pfp
Brock
@runninyeti.eth
Should be 3511 distinct PB holders (3701 non-unique) ``` curl https://api.warpcast.com/v2/power-badge-users | jq '.result.fids | unique | sort | .[]' | wc -l ``` (someday code will format here 🌈)
0 reply
0 recast
2 reactions

Brock pfp
Brock
@runninyeti.eth
Lol I would be curious to overlay the results with the language of choice I'd bet anyone coming from the JS world would think about the code (async = is there a promise?) If you're looking at architecture design more generally, the answer gets flipped
1 reply
0 recast
1 reaction