Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. POHow to do page navigation for many, many pages? Logarithmic page navigation
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USnik
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. CO(b) is usually a good idea, but it's in addition to page navigation links, not a replacement for them. Neither (a) nor (c) really address the problem of quickly navigating to *any* point in a very large list (and (c) could result in a very large number of links, and also would introduce potentially confusing new UI elements). The point about logarithmic pagination is that it scales elegantly from 10s of pages to 10s of million pages (or more), with a UI that's both efficient and easily understood.
      singulars
      1. PO
      1. USDoin
    2. COActually, now that I think about it, if you wanted to, you could easily add feature (c) to my logarithmic pagination algorithm without too much work. You end up with a "flat" list of links centered on the current page, and "logarithmic" links into the remainder of the page list on either side. (How big you make the "flat" part and whether it's size is user-adjustable is up to you, and depends on the requirements of you application, of course).
      singulars
      1. PO
      1. USDoin
    3. COAh, I think I may have misinterpreted your suggestion (a). Maybe you meant +10> +100> +1000> +10000> ... etc, auto-adjusting depending on (the logarithm of) the number of pages? However if you simply replace the +n, -n with absolute page numbers, this is basically a minor variation of the logarithmic scheme above (just slightly changed parameters, and using my suggestion of *not* making the page links "dense" at the endpoints, for compactness). Absolute page numbers are probably better than relative (e.g. -10, +1000) links, for orienting the user, but it's not a big difference.
      singulars
      1. PO
      1. USDoin
 

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