couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthew M. Gamble" <mgam...@mgamble.ca>
Subject Re: Design Question
Date Sun, 06 Dec 2009 22:48:12 GMT
Thanks Roger!

If I go down the "one user, one DB" path is there a limit to the number of databases I can
create?  Any performance issues with having 100k+ unique databases?  

 
------Original Message------
From: Roger Binns
To: user@couchdb.apache.org
ReplyTo: user@couchdb.apache.org
Subject: Re: Design Question
Sent: Dec 6, 2009 5:25 PM

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Matthew Gamble wrote:
> I'm sorry if a question like this has been asked
> before, but I couldn't find anything in the archives that was quite the same
> as what I'm trying to do.

There indeed was a similar discussion.  One of the final conclusions was
that it would be best to have each user plus their data stored in a separate
DB.  The reason for this is that it makes the security rules easier to
define and also makes more sense for replication.  (Presumably you want to
eventually allow the users to run a personal CouchDB with the same database.)

> attachment but that made it very hard to search the data as it required the

May be helpful http://wiki.apache.org/couchdb/Full_text_search

> Or is it best to put each user as their own database and store the address
> books / VCards as documents?

That would be most natural.  In theory you can write an update handler that
parses the vCard into fields and makes them keys of the doc.  If you do this
then the full text search should work really easily.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkscL2oACgkQmOOfHg372QSAwACdGdOXBMw9W7a5jLAeXPHGGz27
Za4An3KylQT6Z788a09Nr1MOH2jiXeFU
=AJpY
-----END PGP SIGNATURE-----


Sent from my BlackBerry device on the Rogers Wireless Network
Mime
View raw message