3 ms·
There are lots of tradeoffs when choosing Cassandra: 1. If you delete data, tombstones are a problem that nobody wants to have to think about. 2. Denormalizin
by bastawhiz 3y ago
There are lots of tradeoffs when choosing Cassandra:
1. If you delete data, tombstones are a problem that nobody wants to have to think about.
2. Denormalizing data instead of joining isn't always practical or feasible.
3. If you're not dealing with large amounts of data, Postgres and MySQL are just easier. There's less headache and it's easier to build against them.
4. One of the big advertised strengths of Cassandra is handling high write volume. Many applications have relatively few writes and large amounts of reads.
- pmcf 3y agoFast writes and slow reads was true in 2012. The project has been busy since.
- bastawhiz 3y agoFast reads are commonplace. Having fast writes for a workload without an especially high volume of writes is not selling anyone on a database.
- swingingFlyFish 3y agoUnless it's a commenting system ;)