19:34
A well-known issue that can come up with Django sites running on PostgreSQL is that connections in “Idle in Transaction” state can pile up. There’s a relatively straight-forward fix, but ultimately, it’s due to a bug in Django’s transaction management, at least when PostgreSQL is the back-end.
Let’s run through it. Read the rest of this entry »
13:34
Here are the slides for my talk at PGXPUG Day OSCON 2010.
13:30
The slides from my talk, Introduction to PostgreSQL are available here.
14:19
The archive video for the February 9, 2010 SFPUG meeting is now available: Read the rest of this entry »
19:46
Brent Simmons has a very good piece about switching away from using Core Data to using SQLite directly in his iPhone app. Substituting “any common ORM” for “Core Data” (which, after all, is all Core Data is) and “any SQL database” for SQLite, he encounters the most common problems that plague those trying to develop scalable solutions on top of ORMs.
13:21
The archive video for the December 8, 2009 SFPUG meeting is now available: Read the rest of this entry »
16:02
The archive video for the November 10, 2009 SFPUG meeting is now available: Read the rest of this entry »
19:23
In part 1, we ran down a list of the standard Django features for controlling transactions. Now, we’re going to look at some ways to optimize how these tranactions happen.
14:40
Django has quite a bit of code in it devoted to transaction management. Although the documentation goes into quite a bit of depth on transactions, I’ve never felt that the docs by themselves let you build a good mental model of how transactions actually work. So, I decided to approach it experimentally: Build a small Django app, and see how the various options actually work.