incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Lehnardt <...@apache.org>
Subject Re: Query across databases
Date Sat, 31 Oct 2009 10:32:36 GMT

On 31 Oct 2009, at 02:45, Devin Guedo wrote:

> hi all,
>
> I was wondering what would be the optimal way to query across  
> databases?
>
> Quick example; you have a SAS blog platform. Each blog has its own  
> database,
> storing the individual posts and comments as separate documents. You  
> write a
> view that counts the comments for individual posts. Essentially a  
> list of
> posts, in order, by their comment count. But, now you want a global  
> list, a
> top 100 posts based on comment count from across the whole site,  
> spanning
> all databases. How would one do that efficiently?

You might be able to bend http://tilgovi.github.com/couchdb-lounge/ in  
that direction.

Cheers
Jan
--


Mime
View raw message