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

Hacking the WiFi-enabled color screen GitHub Universe conference badge - 28th October 2025
Video: Building a tool to copy-paste share terminal sessions using Claude Code for web - 23rd October 2025
Dane Stuckey (OpenAI CISO) on prompt injection risks for ChatGPT Atlas - 22nd October 2025

django 577 michael-trier 4 orm 40 python 1199 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