unjoinify: a module to tame the SQL beast
Tuesday, June 7th
12:05–12:25
Abstract
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.
Talk
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.
Organisation/company | Torchbox |
---|---|
Website | http://matt.west.co.tt/ |
@westdotcodottt | |
Github | gasman |