A place for developers to talk about building on Farcaster.

/dev

anyone built a messaging application before? working on a chatgpt-like app and trying to decide the best way to handle the high volume of writes needed to save messages.

solutions being considered:
- scylla
- redis + daily backup to postgres
- just a beefy pg cluster

curious about people's thoughts on which is best

@operator & /operator | 💭 about BCI, bioinformatics, search, chaos, decentralized AI | join me in /entropybender /llm

you're overcomplicating, built-in number of writes per second is well beyond what you need initially

cto @ bwl.gg (lunchbreak.com), 80M+ users (bdut.ch) 🙏 built @remindme, @mintit, @gpt, @healthbot, farcantasy.xyz

my inclination is this as well, might just try with a postgres first and think about migrating later

This is a good approach to start. Redid+postgress.

Yes right. Postgress alone can handle a lot at this stage.

you don't need redis in 99.9% of cases

skip this complexity