CouchDB create database per document type?

Question

I've just started playing around with couchdb and I'm really liking it so far, but I was wondering when you should be creating a new database.

Here's what I mean:

If i were to create a blog on a server with multiple blogs and this was a RDBMS, I'd create a database called fox_blog and create tables and relations for the posts, comments, etc..

Now in CouchDB, I'd simply make 3 document types: posts, comments and user accounts.

But this is my question: Would I make one db called fox_blog and add a 'type' field to each of the documents (e.g., in the posts documents there would be a 'type' field with the value of 'post')? Or would I make a separate db for each document and precede the name with fox_ (e.g., db name would be fox_posts for the posts)? Or are neither of these correct?

Let me know if any of this is unclear, it was a bit hard to explain heh

Answer 1

You should create a single database with a type field in each document.

You may want to write a view that returns the document and all its comments together.