Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Why Uber Engineering Switched from Postgres to MySQL. Parent comment
You can't use Cassandra if you need atomic increments (yes, they're included but painfully slow due to several trips required to satisfy PAXOS).
Also there are no transaction rollbacks (atomic batches always go one way - forward).
You may hit GC pauses if the JVM is not tuned properly.
If the use case involves its of deletes then tombstone related issues need to be considered.
There are no comments on this comment yet.
You can't use Cassandra if you need atomic increments (yes, they're included but painfully slow due to several trips required to satisfy PAXOS).
Also there are no transaction rollbacks (atomic batches always go one way - forward).
You may hit GC pauses if the JVM is not tuned properly.
If the use case involves its of deletes then tombstone related issues need to be considered.