A place for developers to talk about building on Farcaster.

/dev

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

Building fereai.xyz . Previously co founded Quartic.ai. Did Search & Recommendations at LinkedIn.com

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

Developer 🤓 build, develop and operate Farcaster solutions @ dtech.vision also love tech, decentralization, fitness and oldschool rap 😎

no api, but it's the app I use for search

Recommend content and transactions to your users with custom models pre-trained on Farcaster data. Let's make people's voices heard 🤝 Incubated @a16zcrypto CSX'23 -  https://www.mbd.xyz

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

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;

can you let AI write the SQL queries for you?