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

From Unfuddle (svn) to git

I’ve blogged about converting a Subversion repository to git a couple times. While it was a tedious process at first, I’ve made my peace with it and now cannot count the code repositories I have migrated successfully anymore. The migration usually works, except for when I deal with our old provider unfuddle. For some reason, sometimes it didn’t work right away and I had to re-run git svn clone a couple of times to get it right....

December 8, 2012 · 2 min

From Subversion to GIT (and beyond!)

Here’s a more or less simple way to migrate from Subversion to GIT(hub), this includes mapping commits and tags and what not! Authors If multiple people congtributed to your project, this is probably the toughest part. If you’re not migration from let’s say Google Code but PHP’s Subversion repository, then it’s really pretty simple indeed: the username is the email address. I found a nifty bash script to get it done (and adjusted it a little bit):...

December 9, 2011 · 5 min