Simon Willison’s Weblog

Finding Lookup Items that Are Not Used. How to do left outer joins (and other custom SQL) using the Django ORM.

Posted 13th August 2007 at 5:08 pm

Recent articles

My review of Claude's new Code Interpreter, released under a very confusing name - 9th September 2025
Recreating the Apollo AI adoption rate chart with GPT-5, Python and Pyodide - 9th September 2025
GPT-5 Thinking in ChatGPT (aka Research Goblin) is shockingly good at search - 6th September 2025

django 577 michael-trier 4 orm 40 python 1188 sql 105

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe