Couchdb

This is part II of my introductory series to move from MySQL a relational database (management) system to CouchDB. I will be using MySQL as an example. Part I of this series is available here. Recap In part I, I introduced CouchDB by explaining its basics. I continued by showing a simple request to create a document using curl (on the shell) and expanded how the same request could be written in PHP (using ext/curl) — or in HTTP_Request2 or with phpillow....

I’m posting about this tidbit because Google seemed to know nothing about it. Anyway, during the view building process, we may see the following in the couchdb.log (level = info, at least, in local.ini): [...] [info] [...] checkpointing view update at seq 78163851 for citations _design/erlang [...] [debug] [...] New task status for citations _design/erlang: Processed 17844590 of 107444308 changes (16%) [...] [debug] [...] New task status for citations _design/erlang: Processed 17848060 of 107444308 changes (16%) [....

Update (2009-10-13): I posted part II! This is the first part of a series. I’ll start off by introducing CouchDB — from a PHP side, then I’ll demo a couple basic use cases and I later on, I’ll dive into migrations from MySQL. My idea is to introduce CouchDB to a world where database-driven development generally refers to MySQL. By no means, this is meant to be disrespectful to MySQL, or SQL-databases in general....

I’ve been wrestling with a couple views in CouchDB currently. This blog post serves as mental note to myself, and hopefully to others. As I write this, i’m using 0.9.1 and 0.10.0 in a production setup. Here’s the environment: Amazon AWS L Instance (ami-eef61587) Ubuntu 9.04 (Jaunty) CouchDB 0.9.1 and 0.10.0 database size: 199.8 GB documents: 157408793 On to the tips These are some small pointers which I gathered by reading different sources (wiki, mailing list, IRC, blog posts, Jan …)....

Here’s a little HowTo on how to setup CouchDB on an AWS EC2 instance. But outside of AWS (and EC2), this setup works on any other Ubuntu server, and I suppose Debian as well. Getting started The following steps are a rough draft, or a sketch on how to get started. I suggest that you familiarize yourself with what all of these things do. If you want to skip on the reading and just get started, this should work anyway....