Django

I’ll be presenting “Really, Really Fast Django” at Djangocon EU. Do come! It’s on a private island!

The slides are available here.

I’ll be giving a tutorial at PyCon 2014 in Montréal. Register early and often!

django-pglocks 1.0.2 has been pushed out. This fixes a bug that Aymeric Augustin found that keep a lock from being properly released. He also contributed a test framework to it… many thanks to him for that!

Advisory locks are a very useful feature in PostgreSQL, and they just aren’t used enough.

Here’s a scenario: You have a bulk import job. While that job is running, there’s an analysis job you want to prevent from starting, and you don’t want a bulk import to start while the analysis job is running. But any number of bulk

I often find that I’m in the middle of a loop or something and discover an error. I want to exit the loop in a way that causes the database work I’ve done within it to be rolled back, but I don’t want that exception to propagate further.

This usually looks like:

1
try:
2
   with 

The Call for Papers for DjangoCon US 2013 is now open.

psycopg2, the Python PostgreSQL interface library, is now up to version 2.5. This includes built-in support for the JSON and range types… yay!

The slides for my presentation, “PostgreSQL, Python and Squid” (otherwise known as, “using Python in PostgreSQL and PostgreSQL from Python”) presented at PyPgDay 2013 at PyCon 2013, are available for download.

I presented “PostgreSQL When It’s Not Your Job” at DjangoCon US 2012, and you can get the slides here.

My presentation PostgreSQL When It’s Not Your Job from DjangoCon Europe 2012 is now available here.