All I want is indexes on my DB going forward.

dang cast data aint big, but without indexes it ain't much fun to wait on SQL queries

Farcaster Development Boutique @ https://dTech.vision 💜 in love with tech 🤓decentralization, fitness and oldschool rap 😎

@runninyeti.eth indexing.co into PSQL on a server we have to play around with

Defi. Ethereum. Physics.

Data at @quotient.

Honestly curious if running a hub and running a local db is super expensive. I have a home NAS server. This can't be that big of a technical hurdle.

if you’re building a client i fully understand, for me with mini apps nothings beaten doing a one time bulk sync then just listening for realtime events (no need for ETL, no postgres setup, no schemas, etc) — i do have some local duckdb files with indexes on them tho to be fair

Why would I not to build an app
on top of that data that needs all casts & more indexed nearly live to be accurate  and later on having the ability to enable caching etc on repeat queries

your root issue is you’re putting the stuff in a db

Indexing.co -> PSQL 

Want to finally have a setup to run SQL queries on FC data that doesn’t cost me an arm and a leg a month while also being near real time

I broke my back lifting moloch to heaven. ntik.me