One common database operation that isn't supported out of the box by Django's ORM is create_or_update - in other words, given a set of parameters, either update an existing object or create a new one if there isn't one already.
The naive implementation is to do a get ...
My last post talked about how to follow reverse generic relations efficiently. However, there's a further potential inefficiency in using generic relations, and that's the forward relationship.
If once again we take the example of an Asset model with a GenericForeignKey used to point at Articles and Galleries ...
more ...I've previously talked about how to make reverse lookups more efficient using a simple dictionary trick. Today I want to write about how this can be extended to generic relations.
At its heart, a generic relationship is defined by two elements: a foreign key to the ContentType table, to ...
more ...One of the main sources of unnecessary database queries in Django applications is reverse relations.
By default, Django doesn't do anything to follow relations across models. This means that unless you're careful, any relationship can lead to extra hits on the database. For instance, assuming MyModel has a ...
more ...