Categories
django mysql postgresql psycopg2

What should a Django user know when moving from MySQL to PostgreSQL?

Most of my experience with Django thus far has been with MySQL and mysqldb. For a new app I’m writing, I’m dipping my toe in the PostgreSQL water, now that I have seen the light.

While writing a data import script, I stumbled upon an issue with the default autocommit behavior. I would guess there are other “gotchas” that might crop up. What else should I be on the lookout for?