SQL MAX() and GROUP BY for CouchDB

While re-writing a couple SQL statements into CouchDB we got stuck when we wanted to do a SELECT MAX(...), id ... GROUP BY id in CouchDB. MySQL Imagine the following SQL table with data: In order to get the latest deploy for each project, I’d issue: Simple. But what do you do in CouchDB? CouchDB My documents look like this: So, after more than a couple hours trying to wrap our heads around map-reduce in CouchDB, it’s working....

October 4, 2013 · 1 min

The future of CouchDB

… is not Damien Katz. TL;DR The blog post Damien Katz wrote earlier today, doesn’t mean much or anything for the Apache CouchDB project (or memcache project for that matter). If anything it’s a public note that Damien Katz acknowledged that he moved (on) from CouchDB to Couchbase. Short story, long I’m not a contributor to CouchDB by means of code, (but) I blog a lot, I maintain the FreeBSD port, wrote a book and have an opinion on many things CouchDB....

January 5, 2012 · 4 min

Quo vadis, CouchDB?

Update, 2011-12-21: Couchbase posted their review of 2011 (the other day) — TL;DR: Couchbase Single Server (their Apache CouchDB distribution) is discontinued and its documentation (and its buildtools) will be contributed to Apache CouchDB. When Ubuntu1 dropped CouchDB two weeks ago, there were a couple things which annoy (present tense) me a lot. Add to that the general echo from various media outlets blogs which pronounced CouchDB dead and a general misconception how this situation or CouchDB in general is dealt with....

December 4, 2011 · 9 min

RFC: Mocking protected methods

Update, 2011-06-16, 12:15 AM Thanks for the comments. (I swear I had something like that before and it didn’t work!) Here’s the solution: — Original blog entry — I wrote a couple tests for a small CouchDB access wrapper today. But when I wrote the implementation itself, I realized that my class setup depends on an actual CouchDB server being available and here my journey began. Example code Consider the following example:...

June 15, 2011 · 1 min

Some thoughts on outtages

Cloud, everybody wants it, some actually use it. So what’s my take away from AWS’ recent outtage? Background So first off, we had two pieces of our infrastructure failing (three if we include our Multi-AV RDS) — both of which involve EBS. Numero uno One of those pieces in my immediate reach was a MySQL server, which we use to keep sessions. And to say the least about AWS and in their defense, the instance had run for almost 550 days and had never given us much or any reason to let us down....

April 23, 2011 · 8 min