Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p><em>[Warning, I'm assuming you're running this in some sort of production environment. Just go with the short answer if this is for a school or pet project.]</em></p> <p>The short answer is "yes".</p> <p>The longer answer is that there are some things you need to watch out for...</p> <ul> <li><p>You're going to be playing whack-a-mole with a lot of system settings like max file descriptors.</p></li> <li><p>You'll also be playing whack-a-mole with erlang vm settings.</p></li> <li><p>CouchDB has a "max open databases" option. Increase this or you're going to have pending requests piling up.</p></li> <li><p>It's going to be a PITA to aggregate multiple databases to generate reports. You can do it by polling each database's _changes feed, modifying the data, and then throwing it back into a central/aggregating database. The tooling to make this easier is just not there yet in CouchDB's API. Almost, but not quite.</p></li> </ul> <p>However, the biggest problem that you're going to run into if you try to do this is that CouchDB does not horizontally scale [well] by itself. If you add more CouchDB servers they're all going to have duplicates of the data. Sure, your max open dbs count will scale linearly with each node added, but other things like view build time won't (ex., they'll all need to do their own view builds).</p> <p>Whereas I've seen thousands of open databases on a <a href="http://bigcouch.cloudant.com/" rel="nofollow">BigCouch</a> cluster. Anecdotally that's because of dynamo clustering: more nodes doing different things in parallel, versus walled off CouchDB servers replicating to one another.</p> <p>Cheers.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload