Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#1

Post by kkovacs » Thu, Dec 30, 2010, 5:38 PM UTC

Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison
kkovacs.eu

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#2

Post by arethuza » Thu, Dec 30, 2010, 6:21 PM UTC

My understanding is that in CouchDB you can't guarantee that older versions of documents will still exists (they might be there, but they could have been removed by compaction or not replicated).

However, there is a fairly nice way of storing older versions of documents - hold older versions as file attachments on the document. See:

http://jchrisa.net/drl/_design/sofa/_list/post/post-page?sta...

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#3

Post by mikeytown2 » Thu, Dec 30, 2010, 6:26 PM UTC

I was hoping HandlerSocket would be in here. If you don't know about it, check it out http://news.ycombinator.com/item?id=1886137

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#4

Post by jchrisa » Thu, Dec 30, 2010, 6:28 PM UTC

arethuza wrote: post #2

My understanding is that in CouchDB you can't guarantee that older versions of documents will still exists (they might be there, but they could have been removed by compaction or not replicated). However, there is a fairly nice way of storing older versions of documents - hold older versions as file attachments on the document. See: http://jchrisa.net/drl/_design/sofa/_list/post/post-page?sta...

thanks. latest version of the article is here now http://blog.couchone.com/post/632718824/simple-document-vers...

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#5

Post by kkovacs » Thu, Dec 30, 2010, 6:31 PM UTC

mikeytown2 wrote: post #3

I was hoping HandlerSocket would be in here. If you don't know about it, check it out http://news.ycombinator.com/item?id=1886137

I don't know that one yet, but I promise I'll read up on it! Thanks!

K.

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#6

Post by [deleted] » Thu, Dec 30, 2010, 6:34 PM UTC

[deleted]

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#7

Post by kkovacs » Thu, Dec 30, 2010, 6:36 PM UTC

arethuza wrote: post #2

My understanding is that in CouchDB you can't guarantee that older versions of documents will still exists (they might be there, but they could have been removed by compaction or not replicated). However, there is a fairly nice way of storing older versions of documents - hold older versions as file attachments on the document. See: http://jchrisa.net/drl/_design/sofa/_list/post/post-page?sta...

Yes, if versioning is the main point, then surely one should take special measures to keep them, as in the case of invoices (stornoed, stornos stornoed, etc). As for a CMS system, for example, it's nice to have most of the history, but nobody gets hurt if some gets lost during replication outages, etc.

Just my $0.02 :)

K.

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#8

Post by ocharles » Thu, Dec 30, 2010, 6:37 PM UTC

> While SQL databases are insanely useful tools, their tyranny of ~15 years is coming to an end

This shit, AGAIN? Really? No, they are not.

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#9

Post by kkovacs » Thu, Dec 30, 2010, 6:39 PM UTC

[deleted] wrote: post #6

[deleted]

I meant database consistency in the sense of never needing "repair tables"; although as far as I know, CouchDB's automatic conflict resolution is also consistent (based on UUIDs), isn't it?

Clarified it, thanks!

Re: Cassandra vs MongoDB vs CouchDB vs Redis vs Riak comparison

#10

Post by kkovacs » Thu, Dec 30, 2010, 6:40 PM UTC

ocharles wrote: post #8

> While SQL databases are insanely useful tools, their tyranny of ~15 years is coming to an end This shit, AGAIN? Really? No, they are not.

Not that they get thrown away, they are still very useful. But at least there's an alternative now.

I mean, seriously, Zabbix keeping monitoring data in MySQL? Also Piwik? That's a sick solution, IMHO. :)

(BTW, I love Zabbix and Piwik. Use them both. Only I think that having no good alternate data store at the time of their writing, their data storage is suboptimal.)