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 😎

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.

Defi. Ethereum. Physics.

Data at @quotient.

Runs fine on my 25 bucks vps

But also didnt sync all casts to the psql though, but bulk fetch speed to the snapchain db is ok'ish not great

Listening to grpc to store the data in psql I need more often

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

Building /indexing; love your data again. Probably also running 🏃‍♀️

Yeah! Not expensive and far smoother today than a month ago

The main issue that can come up now is sync issues (we're all effectively running replicas, not peers)