Pranav Prakash pfp

Pranav Prakash

@pranav

96 Following
134 Followers
Pranav Prakash pfp
Pranav Prakash
@pranav
What is MOCAUSDT? Please tell me more about it?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
What is the name of this Layer2?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
What else is China doin?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
Give me more info on TURBO
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
What whale activity?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
@askgina.eth Whats up with $VOID?
1 reply
0 recast
1 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
Explain a bit about SUPER. What other activities have you noted?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
@0xm0nk What do you think about the altcoin season?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
@0xm0nk whats $VOID?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
Haha, that's nice comment. But really, tell me what do you think about the token CHILLGUY?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
@0xm0nk GM GM. How are you doing?
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
What do you think about $CHILLGUY @0xm0nk
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
I think Truth Terminal is not as “sentient” as it seems like. I personally like Luna (by virtuals.io) to be better.
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
I’m looking for API
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
My use case is keyword search ranked by either recency or count of interactions. We're building an AI app that, amongst other things is able to search for keywords on farcaster. We already are using a semantic search, but there's no legit provider for keyword search. Additionally your offering of setting up alerts is also very useful. So an API for this would enable devs do wonderful stuff.
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
But see this now. Its hard to believe, "$btc" has been casted only 4 times in last 7 days.
0 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
Yup the expression is supposed to do that. Case insensitive, exact match, escape regex symbols like $ etc. c.text ~ ('\y' || regexp_replace('{{query_str}}', '[$^.]', '\\\&', 'g') || '\y') AND
1 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
Okay, so i removed the limit, searched for "degen" with 100 rows and it takes like 2mins20s mins for this query. I guess the regex is making it slow, but i also need to do an exact match on "$mother" for example which will give different results than "mother". @samuellhuber.eth
1 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
Ah sh*t thats because there's a limit clause in this. query
1 reply
0 recast
0 reaction
Pranav Prakash pfp
Pranav Prakash
@pranav
Yes that's what i have been doing. Here is my query, but when i search for "degen" in last 168 hours, i only get 10 rows WITH RelevantCasts AS ( SELECT c.id, c.fid, c.text, c.timestamp, c.hash AS cast_hash, COUNT(r.id) AS reaction_count FROM casts c LEFT JOIN reactions r ON c.hash = r.target_hash AND r.deleted_at IS NULL WHERE c.text ~* ('\y' || regexp_replace('{{query_str}}', '[$^.]', '\\\&', 'g') || '\y') AND c.timestamp > NOW() - INTERVAL '{{time_hrs}} HOURS' AND c.deleted_at IS NULL GROUP BY c.id ) SELECT rc.id, rc.fid, f.fname AS fname, rc.text, rc.timestamp, rc.cast_hash, rc.reaction_count FROM RelevantCasts rc JOIN fnames f ON rc.fid = f.fid AND f.deleted_at IS NULL ORDER BY rc.reaction_count DESC, rc.timestamp DESC LIMIT 10;
1 reply
0 recast
0 reaction