What is the default order of a list returned from a Django filter call?

by

There is NO DEFAULT ORDER, a point that can not be emphasized enough because everyone does it wrong.

A table in a database is not an ordinary html table, it is an unordered set of tuples. It often surprises programmers only used to MySQL because in that particular database the order of the rows are often predictable due to it not taking advantage of some advanced optimization techniques. For example, it is not possible to know which rows will be returned, or their order in any of the following queries:

select * from table limit 10
select * from table limit 10 offset 10
select * from table order by x limit 10

In the last query, the order is only predictable if all values in column x are unique. The RDBMS is free to returns any rows in any order it pleases as long as it satisfies the conditions of the select statement.

Though you may add a default ordering on the Django level, which causes it to add an order by clause to every non-ordered query:

class Table(models.Model):
    ...
    class Meta:
        ordering = ['name']

Note that it may be a performance drag, if for some reason you don’t need ordered rows.

More Related Contents:

  1. Convert Django Model object to dict with all of the fields intact
  2. What’s the difference between select_related and prefetch_related in Django ORM?
  3. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  4. Django Aggregation: Summation of Multiplication of two fields
  5. Django JSONField inside ArrayField
  6. How to create an object for a Django model with a many to many field?
  7. django.db.utils.OperationalError Could not connect to server
  8. How to get two random records with Django
  9. How to execute a GROUP BY … COUNT or SUM in Django ORM?
  10. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  11. Django self-referential foreign key
  12. Django orm get latest for each group
  13. LEFT JOIN Django ORM
  14. Serializing Foreign Key objects in Django
  15. Django connection to postgres by docker-compose
  16. How to set up a PostgreSQL database in Django
  17. Composite primary key in django
  18. How do you join two tables on a foreign key field using django ORM?
  19. Direct assignment to the forward side of a many-to-many set is prohibited. Use emails_for_help.set() instead
  20. Case insensitive unique model fields in Django?
  21. Django JSONField filtering
  22. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  23. How to perform OR condition in django queryset?
  24. How to find pg_config path
  25. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  26. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  27. Sorting related items in a Django template
  28. Deploying Django to Heroku (Psycopg2 Error)
  29. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  30. How to perform filtering with a Django JSONField?

Leave a Comment