I'm definitely a database noob so I'm looking for correction -- but isn't the main advantage of CouchDB / Tokyo Cabinet etc. that it's much simpler to spread them horizontally across multiple machines in a similar fashion to memcache? From what I understand, the main problem with MySQL / other traditional databases is that the complexity of your architecture increases dramatically as you go scale beyond one server as you have to deal with all sorts of problems with data replication whereas with CouchDB, it's much more straightforward to spread the data around. Is that correct?<br>
<br>Kyle<br><br clear="all">Research Assistant<br>Entrepreneurship and Technology Center @ BYU<br><a href="http://kyle.mathews2000.com/blog">kyle.mathews2000.com/blog</a><br>
<br><br><div class="gmail_quote">On Tue, May 5, 2009 at 4:29 PM, Mikkel Høgh <span dir="ltr"><<a href="mailto:m@ooh.dk">m@ooh.dk</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">On Wed, May 6, 2009 at 12:02 AM, Chris Johnson <<a href="mailto:cxjohnson@gmail.com">cxjohnson@gmail.com</a>> wrote:<br>
> CouchDB is a RESTful web service package, which has a storage engine<br>
> that uses MVCC (Postgres, Oracle, InnoDB), and b-tree indexes (used by<br>
> most RDBMSs), with sequence ids (supported by most RDBMSs). So,<br>
> really comparing CouchDB to MySQL or Postgres is to compare apples and<br>
> baked tarts made with apples.<br>
<br>
</div>I'd say that's an awesome analogy. If you're not looking for baked<br>
goods, but perhaps apple sauce, raw apples might be preferable…<br>
<br>
On the other hand, if you intent to consume it with whipped cream<br>
anyhow, why not just grab the finished tart while you're at it…<br>
<div class="im"><br>
> And Tokyo Cabinets -- hmmm. Serialized data versus structured data<br>
> and database wide unique keys. DBM primitives? Again, it remains to<br>
> be seen whether it's faster than an SQL engine when combined with<br>
> something like Tokyo Tyrant to provide the needed concurrency<br>
> capabilities.<br>
<br>
</div>Yeah, unless someone is going to actually try to come up with some<br>
real numbers for what it would mean for our use case, this is debate<br>
probably going to be a precious waste of bytes ;)<br>
</blockquote></div><br>