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 | building future.news | BCI, bioinformatics, search, chaos, decentralized AI

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.

you don't need redis in 99.9% of cases

skip this complexity