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

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

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

💻 web3 + solidity developer | building /hyperclient && @gif frame | 👑 get premium @ https://hypersub.withfabric.xyz/s/gif