Skip to main content
Help us improve Python packaging – donate today!

infinite-scroll-pagination is a Django app that implements the *seek method* for scalable pagination..

Project Description

infinite-scroll-pagination is a Django app that implements the seek method (AKA Keyset Paging) for scalable pagination.

How it works

Keyset driven paging relies on remembering the top and bottom keys of the last displayed page, and requesting the next or previous set of rows, based on the top/last keyset

This approach has two main advantages over the OFFSET/LIMIT approach:

  • is correct: unlike the offset/limit based approach it correctly handles new entries and deleted entries. Last row of Page 4 does not show up as first row of Page 5 just because row 23 on Page 2 was deleted in the meantime. Nor do rows mysteriously vanish between pages. These anomalies are common with the offset/limit based approach, but the keyset based solution does a much better job at avoiding them.
  • is fast: all operations can be solved with a fast row positioning followed by a range scan in the desired direction

For a full explanation go to the seek method


infinite-scroll-pagination requires the following software to be installed:

  • Python 2.7
  • Django +1.4 (tested locally on 1.6)


  1. None :smile:


Paging by date or any other field:


from infinite_scroll_pagination.paginator import SeekPaginator

def pagination_ajax(request, pk=None):
    if not request.is_ajax():
        return Http404()

    if pk is not None:
        # I'm doing an extra query because datetime serialization/deserialization is hard
        date = get_object_or_404(Article, pk=pk).date
        # is requesting the first page
        date = None

    articles = Article.objects.all()
    paginator = SeekPaginator(articles, per_page=20, lookup_field="date")
    page =, pk=pk)

    articles_list = [{"title": a.title, } for a in page]
    data = {'articles': articles_list,
            'has_next': page.has_next(),
            'pk': page[-1].pk}

    return HttpResponse(json.dumps(data), content_type="application/json")

Paging by pk or id (special case):


def pagination_ajax(request, pk=None):

    page =, pk=pk)


Showing how many objects (or pages) are left:

Note: For true infinite scroll, this is not recommended. Since it does a count() query.

It would be better if you increase an IntegerField every time a record is saved and do some javascript magic to know how many objects are left.


page_first =

data = {'objects_left_count': page_first.objects_left,
        'pages_left_count': page_first.pages_left,


  • I decided not to implement the get previous page because there is no way to know if the previous page even exists anymore, rows may have been removed. Although, it’d work for dynamic content that inserts rows (but does not delete them). If you have some thoughts about how this can be solved, you may open an issue.
  • Order is DESC (from newest to latest). You may submit a pull request for ASC order support.


Feel free to check out the source code and submit pull requests.

You may also report any bug or propose new features in the issues tracker

Release history Release notifications

History Node


History Node


History Node


History Node


This version
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
django_infinite_scroll_pagination-0.1-py2.7.egg (6.5 kB) Copy SHA256 hash SHA256 Egg 2.7 Apr 11, 2014
django-infinite-scroll-pagination-0.1.tar.gz (6.4 kB) Copy SHA256 hash SHA256 Source None Apr 11, 2014

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page