Databases
StackOverflow2013
Postsdbo
POHow to do page navigation for many, many pages? Logarithmic page navigation
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to do page navigation for many, many pages? Logarithmic page navigation
    primarykey
    data
    text
    <h2>What's the best way of displaying page navigation for many, many pages?</h2> <p>(Initially this was posted as a how-to tip with my answer included in the question. I've now split my answer off into the "answers" section below). </p> <hr> <p>To be more specific:</p> <p>Suppose you're displaying a set of records to the user, broken up into fixed-size pages (like the results of a Google search, for example). If there are only a few pages, you can display a page navigation area at the end of the results that might look like this:</p> <p>[ &lt;&lt; ] [&lt;] 1 2 3 <strong>4</strong> 5 6 7 8 9 10 11 12 13 [ > ] [ >> ]</p> <p>But this quickly becomes unweildy if there are much more than 20 or 30 pages of results.</p> <p>Sometimes you'll see things like this:</p> <p>[ &lt;&lt; ] [&lt;] ... 665 666 667 668 <strong>669</strong> 670 671 672 673 ... [ > ] [ >> ]</p> <p>or this:</p> <p>[ &lt;&lt; ] [&lt;] 1 2 3 ... 667 668 <strong>669</strong> 670 671 ... 845 846 847 [ > ] [ >> ]</p> <p>but in both cases, navigating to anywhere in the middle of the "..." sections would take many, many mousclicks. Sometimes an input box for entering the page number directly is provided; otherwise (assuming we're talking about a webpage here) the savvy user is likely to look at the URL to see if they can edit it directly.</p> <p>What would be nice would be to have a pagination display that lets the user reach any page in only a few mouseclicks, without having ridiculously many links.</p> <p>How would that best be achieved?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDoin
    1. USDoin
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to do page navigation for many, many pages? Logarithmic page navigation
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to do page navigation for many, many pages? Logarithmic page navigation
      1. USOrhaan
      1. VTFavorite
    3. VO
      singulars
      1. POHow to do page navigation for many, many pages? Logarithmic page navigation
      1. USBjörn
      1. VTFavorite
    1. COWho would want to go to page 494 directly, given one's not super smart and knows which content is on what page?
      singulars
      1. POHow to do page navigation for many, many pages? Logarithmic page navigation
      1. USwebjunkie
    2. COwebjunkie, you wouldn't. However you might guess that what you're after is in the high 400s (say) and want to get to that region in only a click or two (instead of 100s of clicks). Then when you're on page 500 you might realize you're a little to high, so you'd try p.490, then 495, and finally you'd find what you need on 494. This style of search requires you to be able to move around in both small and large jumps, to quickly reach _any_ page. This is what my logarithmic pagination method allows for.
      singulars
      1. POHow to do page navigation for many, many pages? Logarithmic page navigation
      1. USDoin
    3. COI like your thinking. However, Stackoverflow is a question and answer site and it's not recommended to post 'howtos'. You should split your post into a question and an answer. It is ok to answer your own question and it gives others a chance to provide their own answers too.
      singulars
      1. POHow to do page navigation for many, many pages? Logarithmic page navigation
      1. USkristianp
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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