News for hackers. Stuff that matters.

A comment on MongoDB vs. PostgreSQL vs. ScyllaDB: Tractian’s Experience. Parent comment

Re:MongoDB vs. PostgreSQL vs. ScyllaDB: Tractian’s Experience by kinghajj on Wednesday May 31, 2023 @04:01PM (#36143447)
Scylla has "tunable" consistency[1][2][3], so it's possible to get consistency without too much of a performance hit, and still be resilient to some failures.

[1]: https://www.scylladb.com/glossary/eventual-consistency/

[2]: https://docs.scylladb.com/stable/cql/consistency.html

[3]: https://docs.scylladb.com/stable/cql/consistency-calculator....

[ Parent | on HN ]
Re:MongoDB vs. PostgreSQL vs. ScyllaDB: Tractian’s Experience by winrid on Wednesday May 31, 2023 @04:05PM (#36143504)
Nice, thanks! I haven't used it yet.
[ Parent | on HN ]
Re:MongoDB vs. PostgreSQL vs. ScyllaDB: Tractian’s Experience by PeterCorless on Thursday June 08, 2023 @01:24PM (#36245468)
On top of this, ScyllaDB also has "Lightweight Transactions" (LWT) that use Paxos to do a compare-and-set (CAS) read-before-write. This is important for strict linearizability. You can think of it really roughly as "single partition ACID."

They are also implementing a Raft infrastructure upon which they will be able to do strong consistency transactions in the future.

https://www.scylladb.com/tech-talk/the-future-of-consensus-i...

[Disclosure: I used to work at ScyllaDB]

[ Parent | on HN ]