‘database’ Entries
-
Apr052010
Moving a django site from MySQL to PostgreSQL
I've recently worked on a project where the client initially insisted on using MySQL for their website. I didn't have any reasons at the time to protest this choice since MySQL is ok for majority of sites and so I used MySQL as per their request.
With the latest updates to their website, we have however run into some MySQL limitations, in particular the default storage engine that MySQL uses.
We added an application called South to django, which manages database migrations as the models are updated etc. South works brilliantly …