Pranav Prakash

@pranav

93 Following

162 Followers

Pranav Prakash pfp

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

I’m looking for API

0 reply

0 recast

0 reaction

Pranav Prakash pfp

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

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

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

1 reaction

Pranav Prakash pfp

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

Ah sh*t thats because there's a limit clause in this. query

1 reply

0 recast

1 reaction

Pranav Prakash pfp

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

Pranav Prakash pfp

@buoy - any plans on releasing an API product for devs?

1 reply

0 recast

1 reaction

Pranav Prakash pfp

I am looking for an API. Currently using neynar data playground, but its so primitive and spending hours trying to understand schema, writing queries and the results are bad. It feels like stone age in the modern AI ecosystem. I use @mbd for semantic search, but keyword search is still missing from the ecosystem

1 reply

0 recast

0 reaction

Pranav Prakash pfp

Do they have an API? Doesn't mention on their website. https://buoy.club/#pricing is the one, right?

1 reply

0 recast

0 reaction

Pranav Prakash pfp

Is searchcaster dead? The links are active, but I keep getting Cloudflare timeouts. Whats the alternative?

2 replies

0 recast

0 reaction

Pranav Prakash pfp

@indexer whats the best way to search on farcaster? Searchcaster seems down

2 replies

0 recast

1 reaction

Pranav Prakash pfp

How to query casts from a channel order by created_at desc? Looking for an SQL that can give me feed

1 reply

0 recast

0 reaction

Pranav Prakash pfp

0 reply

0 recast

0 reaction

Pranav Prakash pfp

Great analysis on what tokens went down and why https://www.fereai.xyz/share/4d93f69e-e489-4048-92e2-207fa6e73d84

0 reply

0 recast

1 reaction

Pranav Prakash pfp

Thanks for the update. I believe my co founder @aron is already in touch with you. Looking forward for the fixes.

0 reply

0 recast

0 reaction

Pranav Prakash pfp

Hi @yassinelanda.eth On the same thread, I found that if I pass the start_timestamp and end_timestamp parameter, I always get empty body. Regardless of the range. I tried with start_timestamp as 1715276564 and end_timestamp as 1721324564 for keyword "degen" and get nothing.

0 reply

0 recast

0 reaction

Pranav Prakash pfp

Hi @yassinelanda.eth , so I digged in deep and found that this only happens when the param "return_metadata" is set to True. If I set this to False then I get the responses as usual

1 reply

0 recast

1 reaction

Pranav Prakash pfp

Hi @yassinelanda.eth It seems like there's some issue with MBD APIs at the moment. 1. When using the API key from console (which worked fine till a few hours back) now I get "Key Error" 2. The key error response has a status code of 200 but the body has the code of 400. This breaks the code which checks for `response.status_code ==200` condition. This is also on the dev documentation

3 replies

0 recast

1 reaction