Simon Willison’s Weblog

Subscribe

Posts tagged sql in 2007

Filters: Year: 2007 × sql × Sorted by date

django-mptt (via) Jonathan Buchanan’s simple utility for performing Modified Preorder Tree Traversal (efficient tree operations in SQL) on Django models.

# 29th December 2007, 11:33 am / django, djangoorm, jonathan-buchanan, models, modifiedpreordertreetraversal, mptt, python, sql

A Visual Explanation of SQL Joins. It turns out Venn diagrams are an excellent way of illustrating joins.

# 12th October 2007, 9:42 am / jeff-atwood, sql, venndiagrams

DbMigration—a schema migration tool for Django. Nice and simple tool for adding schema migrations to a Django application.

# 27th September 2007, 3:04 pm / django, djangoorm, migrations, orm, python, sql

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

# 13th August 2007, 5:08 pm / django, michael-trier, orm, python, sql

Storm. New Python ORM from Canonical, emphasising multiple database support, intelligent local cache invalidation and a thin layer over the underlying SQL.

# 9th July 2007, 8:44 am / canonical, orm, python, sql, storm

SELECT * FROM everything, or why databases are awesome. I’m beginning to think that for scalable applications the thinner your ORM is the better—if you even use one at all.

# 22nd June 2007, 12:40 am / blaine-cook, databases, orm, rails, scaling, sql, twitter

Facebook Query Language. The Facebook API now lets you run SQL-like queries. You can’t do joins but you can perform very simple subselects.

# 25th February 2007, 12:06 pm / apis, facebook, sql, webapis

Types

Years

Months

Tags