Pagination in CouchDB?

by

The CouchDB Guide has a good discussion of pagination, including lots of sample code, here: http://guide.couchdb.org/draft/recipes.html#pagination
Here’s their algorithm:

  • Request rows_per_page + 1 rows from the view
  • Display rows_per_page rows, store last row as next_startkey
  • As page information, keep startkey and next_startkey
  • Use the next_* values to create the next link, and use the others to create the previous link

N.B.: The proper way to fetch pages in CouchDB is by specifying a starting key, not a starting index like you might think. But how do you know what key to start the 2nd page on? The clever solution: “Instead of requesting 10 rows for a page, you request 11 rows, but display only 10 and use the values in the 11th row as the startkey for the next page.”

If you expect to have multiple documents emit identical keys, you’ll need to use startdocid in addition to startkey to paginate correctly. The reason is that startkey alone will no longer be sufficient to uniquely identify a row. Those parameters are useless if you don’t provide a startkey. In fact, CouchDB will first look at the startkey parameter, then it will use the startdocid parameter to further redefine the beginning of the range if multiple potential staring rows have the same key but different document IDs. Same thing for the enddocid.

More Related Contents:

  1. RxJs Observable Pagination
  2. Is php pagination compulsory?
  3. How do I limit the number of rows returned by an Oracle query after ordering?
  4. What is the best way to paginate results in SQL Server
  5. How to do paging in AngularJS?
  6. How to paginate with Mongoose in Node.js?
  7. Paginating text in Android
  8. ResultSet to Pagination
  9. MySQL pagination without double-querying?
  10. Ruby on Rails will_paginate an array
  11. Implement paging (skip / take) functionality with this query
  12. Get a count of total documents with MongoDB when using limit
  13. SQL syntax term for ‘WHERE (col1, col2) < (val1, val2)'
  14. How to create a Scroll View with a page control using swift? [closed]
  15. How to provide pagination support to a JTable in Swing?
  16. How to paginate Django with other get variables?
  17. How to do page navigation for many, many pages? Logarithmic page navigation
  18. How do I implement pagination in SQL for MS Access?
  19. How to include pagination in a WordPress Custom Post Type Query
  20. Why should I use document based database instead of relational database?
  21. Pagination: Server Side or Client Side?
  22. How does paging in facebook javascript API work?
  23. Determining when scrolled to bottom of a page with Javascript
  24. MongoDB ranged pagination
  25. Serialize and Deserialize Objective-C objects into JSON
  26. How can I select rows in MySQL starting at a given row number?
  27. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  28. Ajax Pagination in PagedList.MVC using partial Page
  29. Pros/cons of document-based databases vs. relational databases
  30. PHP/MySQL Pagination

Leave a Comment