how to get a certain number of elements from the database django

Question

I have a simply class

class BlogPost(models.Model):
title = models.CharField(max_length=150)
...
timestamp = models.DateTimeField()

How do I get the last five items from the database. I tried to do like this:

posts = BlogPost.objects.<any code>

Excuse me for bad English

Answer 1

You need to invest some time in Reading The Friggin' Manual. Django is one of the best documented open source projects on the planet.

Her's the specific thing you want to read, Limiting QuerySets, but you really need to read the whole page (and a few others) if you are going to do anything meaningful with Django.

Answer 2

You use the array-slicing syntax to index into your queryset, and you use the reverse() function to reverse the queryset before indexing, e.g., myQuerySet.reverse()[:5]. See the docs for more details.

Answer 3

BlogPost.objects.order_by('-timestamp')[:5]

Answer 4

I think that ordering by id it's faster than sorting by any other field.