http://simonwillison.net/2009-11-23T16:19:52+00:00Simon Willison2009-11-23T16:19:52+00:002009-11-23T16:19:52+00:00https://simonwillison.net/2009/Nov/23/batchselect/#atom-tag

<p><strong><a href="http://github.com/lilspikey/django-batch-select">django-batch-select</a></strong></p> A smart attempt at solving select_related for many-to-many relationships in Django. Add a custom manager to your model and call e.g. <code>Entry.objects.all()[:10].batch_select("tags")</code> to execute two queries - one pulling back the first ten entries and another using an "IN" query against the tags table to pull back all of the tags for those entries in one go. <p><small></small>Via <a href="http://www.psychicorigami.com/2009/11/23/django-batch-select/">Psychic Origami</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/batchselect">batchselect</a>, <a href="https://simonwillison.net/tags/django">django</a>, <a href="https://simonwillison.net/tags/john-montgomery">john-montgomery</a>, <a href="https://simonwillison.net/tags/manytomany">manytomany</a>, <a href="https://simonwillison.net/tags/orm">orm</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/selectrelated">selectrelated</a>, <a href="https://simonwillison.net/tags/sql">sql</a></p>

2008-07-29T13:58:45+00:002008-07-29T13:58:45+00:00https://simonwillison.net/2008/Jul/29/extra/#atom-tag

<p><strong><a href="http://www.djangoproject.com/documentation/model-api/#extra-fields-on-many-to-many-relationships">Extra fields on many-to-many relationships</a></strong></p> Checked in just over an hour ago, Django now lets you specify a custom “through” table for a ManyToManyField. Great work by Eric Florenzano. <p><small></small>Via <a href="http://code.djangoproject.com/changeset/8136">Changeset 8136</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/django">django</a>, <a href="https://simonwillison.net/tags/eric-florenzano">eric-florenzano</a>, <a href="https://simonwillison.net/tags/manytomany">manytomany</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/through">through</a></p>