20 ms·
CouchDB & MongoDB both share one property that this comparison misses (or mentions only in passing). Both are schema free datastores. For me, this is the bigge
by nl 16y ago
CouchDB & MongoDB both share one property that this comparison misses (or mentions only in passing).
Both are schema free datastores. For me, this is the biggest, most useful difference between them and traditional SQL databases, because it makes things easy that are very, very hard (or inefficient) on an SQL database.
It's probably also worth noting that other NoSQL solutions don't share this advantage. For example, Cassandra requires all nodes to be restarted to apply a schema change, which can be quite a big deal.
- tylerhobbs 16y ago"Cassandra requires all nodes to be restarted to apply a schema change, which can be quite a big deal." That's no longer true. In 0.7, keyspaces and column families may be created, altered, or dropped live.
- nl 16y agoI thought it might have been fixed by now. Anyway, you still need a schema with Cassandra.
- rbranson 16y agoNot in the same sense as an SQL database. You can freely add columns and rows, just not Column Families or Keyspaces. This is because a KS+CF combo is stored in it's own file, in a certain order, so that it can be efficiently traversed using natural ordering. If you don't have this need and just need a flat K/V database, you can use a single KS+CF for everything.