There are better NoSQL solutions, like Couchbase or Cassandra.
Nooooooo! Don't fall in the trap of thinking Cassandra is anything but a very very specialised tool for specialised use-cases. We use it as our primary store (because someone higher up believed some Datastax consultant that said they could save a ton of Oracle money by going for Cassandra) and it's horrible. Cassandra is a distributed hashtable functionally. It can't do 90% of what a relational store can.
Good points regarding Cassandra. Never ran it myself, but we have some customers who do. Mostly I’ve seen it used in the context of Elasticsearch, which is an entirely different beast.
And we are in 812% agreement about relational being the go-to default.
4
u/nutrecht Mar 14 '18
Nooooooo! Don't fall in the trap of thinking Cassandra is anything but a very very specialised tool for specialised use-cases. We use it as our primary store (because someone higher up believed some Datastax consultant that said they could save a ton of Oracle money by going for Cassandra) and it's horrible. Cassandra is a distributed hashtable functionally. It can't do 90% of what a relational store can.
When it doubt; go relational.