What is a Django QuerySet?

gath picture gath · Jan 13, 2011 · Viewed 37.5k times · Source

When I do this,

>>> b = Blog.objects.all()
>>> b

I get this:

>>>[<Blog: Blog Title>,<Blog: Blog Tile>]

When I query what type b is,

>>> type(b)

I get this:

>>> <class 'django.db.models.query.QuerySet'>

What does this mean? Is it a data type like dict, list, etc?

An example of how I can build data structure like a QuerySet will be appreciated.

I would want to know how Django builds that QuerySet (the gory details).

Answer

Bernhard Vallant picture Bernhard Vallant · Jan 13, 2011

A django queryset is like its name says, basically a collection of (sql) queries, in your example above print(b.query) will show you the sql query generated from your django filter calls.

Since querysets are lazy, the database query isn't done immediately, but only when needed - when the queryset is evaluated. This happens for example if you call its __str__ method when you print it, if you would call list() on it, or, what happens mostly, you iterate over it (for post in b..). This lazyness should save you from doing unnecessary queries and also allows you to chain querysets and filters for example (you can filter a queryset as often as you want to).