DjangoCon Europe 2011

Amsterdam 2011

Talks Pakhuis de Zwijger

June 6th, 7th, 8th

Sprints De Waag

9th & 10th

Thanks, Amsterdam—DjangoCon Europe 2011 was a blast!
Join us next year in Switzerland for DjangoCon Europe 2012.

This conference is made possible by…

unjoinify: a module to tame the SQL beast

Tuesday, June 7th



We all know the golden rule of query optimisation: make one big query rather than lots of little ones in a loop. However, that's easier said than done when you're dealing with deeply nested data - there's a limit to what you can do with Django's own mechanisms like select_related. Often the only answer is to drop down to raw SQL, and in those cases we'd still like to have access to our models, rather than abandoning ORM entirely. This talk presents unjoinify, a helper module that can reassemble gnarly cross-table SQL resultsets back into template-friendly object trees.



Download slides


About Matt Westcott

Matt Westcott is a senior developer at Torchbox - a leading web agency in the charity and not-for-profit sector based in Oxfordshire, UK - who jumped ship from Ruby and Rails to Django in mid-2009, and has since completed a variety of Django-based sites for clients including Oxfam and WWF. He regularly hops between client and server-side, plays an active part in the demo scene digital arts community, and his geek claim to fame is writing a ZX Spectrum emulator in Javascript.