Comment on What software stack would you have chosen for Lemmy?
ArtemZ@nowoke.social 10 months ago
I’d probably go with a different database engine. Postgres is not scaling really well and poorly suitable to throughput intensive applications like tracking activities, upvotes etc.
ICastFist@programming.dev 10 months ago
Which one would you pick? Cockroach?
ArtemZ@nowoke.social 10 months ago
Probably a big data oriented NoSQL database like ScyllaDB. It provides eventual consistency with fast and efficient reads and writes, but high availability, which seems like a perfect fit for the case. CockroachDB favors consistency in place of availability which doesn’t seem to be really a priority for Lemmy instances. You would rather have some upvotes, posts and comments missing sometimes than not being able to load the rest of the data.