This tutorial is meant to get you up and running with ColdFusion and CouchDB. If you have never heard about CouchDB i suggest you read Matt Woodward's slighty chaotic but very informative article about CouchDB.

Step 1: Getting a CouchDB instance up and running

Currently (as of version 0.10) CouchDB is available for Linux and Mac. If you are running Linux, you might know how to get it up and running. If you got a Mac available (either your own or in your network) then things are very easy. Just download CouchDBX and you are ready to go in 1 minute.

After you started CouchDB you will see the administration interface called Futon. If you want to reach your CouchDB from another server, you will have to change the IP address on which CouchDB listens to requests:

Set the bind_address to 0.0.0.0 to make it listen to all requests or set it to the IP of that machine (e.g. 192.168.120.120) so it can only be reached within your network. If you leave it to the default (127.0.0.1) you will have a hard time reaching CouchDB through the network.

While pumping lots of records / docs / bulk inserts to the new CouchDB Server i got a mysterious connection timeout that appeared always after about 4000+ inserted records.

By using cfhttp.errorDetail i got the error:

I/O Exception: Address already in use: connect

To save you some time here is what i found.

While playing around with CouchDB, ColdFusion and SerializeJSON i found that the SerializeJSON does not honor the SetLocale setting. It will use the "Java Default Locale" which is set for the JRE.

So if your Windows installation is German, you will have a DE_de locale.

Now if you us SerializeJSON for a date you will get a date like "März, 21. 2009". Not really good to use this in another DB.