Select top/latest 10 in couchdb?

Posted by drozzy on Stack Overflow See other posts from Stack Overflow or by drozzy
Published on 2010-04-06T03:31:15Z Indexed on 2010/04/06 3:33 UTC
Read the original article Hit count: 157

Filed under:

couchdb

How would I execute a query equivalent to "select top 10" in couch db?

For example I have a "schema" like so:

title   body   modified

and I want to select the last 10 modified documents.

As an added bonus if anyone can come up with a way to do the same only per category. So for:

title   category   body   modified

return a list of latest 10 documents in each category.

I am just wandering if such a query is possible in couchdb.

Related posts about couchdb

How-to index arrays (tags) in CouchDB using couchdb-lucene

as seen on Stack Overflow - Search for 'Stack Overflow'
The setup: I have a project that is using CouchDB. The documents will have a field called "tags". This "tags" field is an array of strings (e.g., "tags":["tag1","tag2","etc"]). I am using couchdb-lucene as my search provider. The question: What function can be used to get couchdb-lucene to index… >>> More
CouchDB crashes at startup when path to config file has space(s)

as seen on Server Fault - Search for 'Server Fault'
I'm hoping to run CouchDB as a per-user Launch Agent on OS X. I'm using the coucdbx-core folder from the CouchDB Server.app as the base of my CouchDB deployment. I'd like each user to have their own couch instance (on a different port), necessitating separate config files for each instance. The logical… >>> More
How to remove all Couchdb versions in Ubuntu 10.04 (server)? ( after multiple installs )

as seen on Server Fault - Search for 'Server Fault'
Hi all, I have done multiple installs of CouchDB using sudo aptitude install couchdb sudo ap-get install couchdb and more recently based on the instructions found at L http://wiki.apache.org/couchdb/Installing_on_Ubuntu May I know how do I uninstall or remove all the above installations? Best… >>> More
How can I proxy couchDB as a sub-diectory with lighttpd?

as seen on Server Fault - Search for 'Server Fault'
I have a sub-directory on my web server (lighttpd) that I want to point at a CouchDB instance running on the same machine. I tried using mod_proxy but it sends along the whole request, like a proxy should, I know! So: // What happens: Lighttpd: http://localhost/couchdb/some_request | V CouchDB:… >>> More
Map/Reduce on an array of hashes in CouchDB

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, I am looking for a map/reduce function to calculate the status in a Design Document. Below you can see an example document from my current database. { "_id": "0238f1414f2f95a47266ca43709a6591", "_rev": "22-24a741981b4de71f33cc70c7e5744442", "status": "retrieved image urls"… >>> More

Developer IT

Select top/latest 10 in couchdb? - Developer IT

Select top/latest 10 in couchdb?

couchdb

Related posts about couchdb

How-to index arrays (tags) in CouchDB using couchdb-lucene

CouchDB crashes at startup when path to config file has space(s)

How to remove all Couchdb versions in Ubuntu 10.04 (server)? ( after multiple installs )

How can I proxy couchDB as a sub-diectory with lighttpd?

Map/Reduce on an array of hashes in CouchDB

Categories cloud