Moving From CouchDB To MySQL 283
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.
Comment removed (Score:5, Funny)
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)