Feed Sign in with OpenID OpenID

Simon Willison’s Weblog

19 items tagged “orm”

jQuery style chaining with the Django ORM

Django’s ORM is, in my opinion, the unsung gem of the framework. For the subset of SQL that’s used in most web applications it’s very hard to beat. It’s a beautiful piece of API design, and I tip my hat to the people who designed and built it. [... 820 words]

Queryset-refactor branch has been merged into trunk. Malcolm’s latest Django masterpiece is complete. 0 27th April 2008, 7:21 am

mysql_cluster (via) My Russian isn’t all that good, but this looks like a neat way of getting Django to talk to a master/slave setup, written by Ivan Sagalaev. UPDATE: English docs are linked from the comments. 2 21st March 2008, 8:45 am

Queryset Implementation. Malcolm explains the work that has gone in to the queryset-refactor branch. Executive summary: Python’s ORM is probably a lot better at SQL than you are. 1 19th March 2008, 9:43 am

Caching Layer for Django ORM. Interesting extension to Django’s ORM that adds automatic caching of queysets and smart cache invalidation. 0 23rd January 2008, 3:18 pm

Announcing StaticGenerator for Django. Simple but powerful static file generator for Django applications—just tell it about your model instances and it will create an entire static site based on calling get_absolute_url() on each one. Uses signals to repopulate the cache when a model changes. 0 7th January 2008, 9:26 pm

Django Evolution. Really smart take on the problem of updating database tables to reflect changes to Django models. Code that automatically modifies your database tables can be pretty scary, but Evolution seems to hit the right balance. 0 23rd November 2007, 11:49 pm

Using the extra() QuerySet modifier in Django for WeGoEat. You can use select() on a QuerySet to obtain extra values using subqueries. 0 24th October 2007, 7:28 pm

tranquil. Inspired take on the Django ORM to SQLAlchemy problem: lets you define your models with the Django ORM but use SQLAlchemy to run queries against them. 0 9th October 2007, 2:30 am

DbMigration—a schema migration tool for Django. Nice and simple tool for adding schema migrations to a Django application. 0 27th September 2007, 3:04 pm

django-sphinx (via) More code from Curse Gaming; this time a really nice API for adding Sphinx full-text search to a Django model. 1 9th September 2007, 12:35 am

AuditTrail. Add change tracking and history to a Django model with a single line of code. Doesn’t handle relationships though, which is definitely the toughest part of this problem. 0 15th August 2007, 1 pm

Finding Lookup Items that Are Not Used. How to do left outer joins (and other custom SQL) using the Django ORM. 0 13th August 2007, 5:08 pm

A nice example of when to use reduce in python. As a shortcut for assembling a large OR query using the Django ORM. 1 2nd August 2007, 11:51 pm

Undelete in Django. Inspired by the conversation about undo the other day, Nathan Ostgard created a simple solution based around custom managers and a trashed_at model field. 1 20th July 2007, 6:54 pm

Storm. New Python ORM from Canonical, emphasising multiple database support, intelligent local cache invalidation and a thin layer over the underlying SQL. 0 9th July 2007, 8:44 am

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. 6 22nd June 2007, 12:40 am

Google Gears DB Abstractions. Here come the ORMs. 1 4th June 2007, 8:54 am

Data::ObjectDriver. Benjamin Trott’s Perl ORM, with built in support for both caching and data partitioning. I think this is what Six Apart uses for Vox. 0 25th February 2007, 12:43 am

A django site