MySQL vs PostgreSQL? Which should I choose for my Django project?

mysql django database postgresql django-migrations
rmh picture rmh · Feb 25, 2009 · Viewed 34.8k times · Source

My Django project is going to be backed by a large database with several hundred thousand entries, and will need to support searching (I'll probably end up using djangosearch or a similar project.)

Which database backend is best suited to my project and why? Can you recommend any good resources for further reading?

Answer

oivvio picture oivvio · May 11, 2010

For whatever it's worth the the creators of Django recommend PostgreSQL.

If you're not tied to any legacy system and have the freedom to choose a database back-end, we recommend PostgreSQL, which achives a fine balance between cost, features, speed and stability. (The Definitive Guide to Django, p. 15)

Related questions

AWS: can't connect to RDS database from my machine

The EC2 instance/live web can connect just fine to the RDS database. But when I want to debug the code in my local machine, I can't connect to the database and got this error: OperationalError: (2003, "Can't connect to MySQL …

Read More
What's the best way to migrate a Django DB from SQLite to MySQL?

I need to migrate my db from sqlite to mysql, and the various tools/scripts out there are too many for me to easily spot the safest and most elegant solution. This seemed to me nice http://djangosnippets.org/snippets/14/ …

Read More
How to move a model between two Django apps (Django 1.7)

So about a year ago I started a project and like all new developers I didn't really focus too much on the structure, however now I am further along with Django it has started to appear that my project layout …

Read More