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

redis + sync to postgres with pgvector is a great way to go

💻 building /hyperclient && @atlas && @gif composer action (check bio for details) | 👑 support me and @gif project by subbing to https://hypersub.xyz/s/gif

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

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

what stuff were you writing to cassandra?

I have used Cassandra DB for heavy write workload. It’s multi master architecture complements this use case.

Did not know about Scylla DB. Seems to be a good choice