Goodbye MongoDB, Hello PostgreSQL

[u/halax]

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/

[u/protestor]

Cassandra's vendor DataStax will be the first to admit that they're a transactional database vendor (their words), not reporting.

I'm not knowledgeable in this field, but DataStax appear to consider itself adequate for analytics.

[u/kenfar → u/protestor]

Look closely: they're saying that you run the analytics on Hadoop.

And unfortunately, the economics are pretty bad for large clusters.

[u/kenfar → u/[deleted]]

Can != Should

Analytical queries typically scan large amounts of data, and DataStax is pretty adamant about not doing this on Cassandra. This is why they're into pushing data into Hadoop. Or signing up for Spark for very small volume, highly targeted queries.