toastdriven/django-tastypie — pull request #675 by philipn (2012-09-23 02:29:48+00:00)
Title: We need a set order_by for reliable pagination.

Without a set ORDER BY, the limit/offset method of pagination won't always be reliable. See http://www.postgresql.org/docs/8.2/static/queries-limit.html. Databases may return results in a predictable manner, but they don't have to. I ran into this issue while working with a 200k+ model table, where many results were repeated.

We could ask that people provide a sorted queryset when constructing their ModelResource, but I feel like that's a leaky abstraction.