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

Adding dynamic features to an aggressively cached website - 28th January 2026
ChatGPT Containers can now run bash, pip/npm install packages, and download files - 26th January 2026
Wilson Lin on FastRender: a browser built by thousands of parallel agents - 23rd January 2026

django 583 michael-trier 4 orm 40 python 1223 sql 109

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