Moving From CouchDB To MySQL 283
Posted
by
Unknown Lamer
from the hep-cats-just-use-postgres dept.
from the hep-cats-just-use-postgres dept.
itwbennett writes "Sauce Labs had outgrown CouchDB and too much unplanned downtime made them switch to MySQL. With 20-20 hindsight they wrote about their CouchDB experience. But Sauce certainly isn't the first organization to switch databases. Back in 2009, Till Klampaeckel wrote a series of blog posts about moving in the opposite direction — from MySQL to CouchDB. Klampaeckel said the decision was about 'using the right tool for the job.' But the real story may be that programmers are never satisfied with the tool they have."
Of course, then they say things like: "We have a TEXT column on all our tables that holds JSON, which our model layer silently treats the same as real columns for most purposes. The idea is the same as Rails' ActiveRecord::Store. It’s not super well integrated with MySQL's feature set — MySQL can’t really operate on those JSON fields at all — but it’s still a great idea that gets us close to the joy of schemaless DBs."
Re:Has to be said (Score:5, Funny)
MongoDB is Webscale. MySQL is not Webscale, because it uses joins. SQL also has impetus mismatch.
Re:Why not PostgreSQL? (Score:5, Funny)
Because it's an urban myth.
The reality is there are only two SQL databases in the entire universe: MySQL and Oracle. You might have been told others exist, hell, you might even have worked on something called "SQL Server" in your .NET shop, but in reality: they don't. They're all figments on your imagination. Your imagination is SO determined to find better, more robust, faster, powerful, alternatives to MySQL and Oracle that an entire fantasy world comprised of "a successor to Ingres that makes MySQL look like a piece of crap" and "A Microsoft product that doesn't feel like a thirty year old mainframe product hacked onto a modern platform" develops in your head.
C'mon, if these mythical products actually existed, sites like Slashdot wouldn't ignore them, right? Right?
Re:Then what's it called instead of a join? (Score:5, Funny)
Witchcraft.
Re:Wikipedia and Slashdot use MySQL (Score:5, Funny)
MongoDB can write its data to /dev/nul/ for extra performance.
Re:Wikipedia and Slashdot use MySQL (Score:3, Funny)
If /dev/null is webscale then I will use it.
COBOL is cool! (Score:4, Funny)
PERFORM makemoney UNTIL rich.
(Note the the full stop at the end)