Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

Fast sequential objects pagination for Django

Project Description


Paginate ordered Django querysets sequentially with “Next” button. Fully compatible with django-el-pagination (but doesn’t depend on it).

The pagination is performed by object ID (or any other set of fields that give strict linear order) rather than by page number. Instead of ?page=2, ?page=3, etc., it produces links like ?from=11, ?from=21 and so on. This gives the following benefits:

  • The pagination works extremely fast even on huge data sets. For example, on Postgres “normal” pagination may take seconds (or even minutes) on queries like ?page=1000000.
  • It prevents duplicates on next page when new data is injected at top and shifts page boundaries (this is especially important for AJAX pagination).

The drawback is that there is no navigation to arbitrary page number and no reverse navigation, it’s always only the link to “Next page” (or nothing at the last page).


pip install django-sequential-pagination


Add django_sequential_pagination to INSTALLED_APPS:



Pass an ordered queryset to the template:


def recent_posts(request):
        return render(request, "blog/posts.html", {
                'posts': Post.objects.all().order_by('-time', '-id'),

Make sure that the ordering always has a tie breaker as the last key, otherwise you may get duplicates on page boundaries.

Now, paginate objects in the template:

{% load pagination %}

{% paginate posts per_page=10 as page %}

{% for post in page.objects %}
        <div>Post #{{ }}</div>
{% endfor %}

{% if page.next_page_url %}
        <a href="{{ page.next_page_url }}">Next</a>
{% endif %}


You can override the default settings in your

SEQUENTIAL_PAGINATION_KEY = 'from'  # querystring key to use, as in ?from=XXXX


You can enable endless pagination with django-el-pagination by putting this in the page template:

{% paginate posts per_page=10 key='page' as page %}

{% for post in page.objects %}
        <div>Post #{{ }}</div>
{% endfor %}

{% if page.next_page_url %}
        <nav class="endless_container">
                <ul class="pagination"><!-- Bootstrap v3 styles -->
                                <a class="endless_more" href="{{ page.next_page_url }}" rel="{{ page.key }}">Show more</a>
{% endif %}

        $.endlessPaginate({paginateOnScroll: true});

Make sure the pagination key (or SEQUENTIAL_PAGINATION_KEY) matches your AjaxListView.key. The defaults are different (from and page, respectively).


If Jinja2 is installed, django_sequential_pagination.templatetags.pagination will be a jinja2.contextfunction.

Additionally, if django_jinja is installed, it will be registered automatically as a template tag, so you can use it right away:

{% set page = paginate(posts, per_page=10) %}

{% for post in page.objects %}
        <div>Post #{{ }}</div>
{% endfor %}

{% if page.next_page_url %}
        <a href="{{ page.next_page_url }}">Next</a>
{% endif %}

Release History

This version
History Node


History Node


History Node


History Node


Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, Size & Hash SHA256 Hash Help File Type Python Version Upload Date
(4.3 kB) Copy SHA256 Hash SHA256
Source None Nov 21, 2016

Supported By

Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Kabu Creative Kabu Creative UX & Design Google Google Cloud Servers Fastly Fastly CDN StatusPage StatusPage Statuspage DigiCert DigiCert EV Certificate