> I know that PostgreSQL is recommended, but why? Are the django > developers assuming a high-traffic, database intensive site. Are the > django developers assuming that you will not be using shared hosting?
Any of the big three (PostgreSQL, MySQL, and sqlite) are quite well supported in Django. In my (highly subjective) experience, the following applies: PostgreSQL: -scaling: +2 -able to be run on a 2nd server: yes -easy administration: 0 -easy configuration/installation: -1 -ANSI SQL compliance: +2 MySQL: -scaling: +1 -able to be run on a 2nd server: yes -easy administration: +1 -easy configuration/installation: 0 -ANSI SQL compliance: +1 (formerly "-1.5") sqlite: -scaling: -1 -able to be run on a 2nd server: not really -easy administration: +1 -easy configuration/installation: +1.5 -ANSI SQL compliance: +1.5 To me, that means, if you've got a site that doesn't need to scale because it should experience minimal traffic, go with sqlite. Especially for local development. If you're entertaining a site that needs to scale, go with PostgreSQL unless you have a reason to prefer MySQL (pre-existence on the hosting service, or ease of getting it running). MySQL's ANSI compliance has improved considerably since the days I cursed its lack of things like views and subselects, but there are still a few common ANSI features missing, or you have to specify features on the table creation (though Django does provide initial-sql hooks on a per-backend basis). I think it's this historical baggage of non-ANSI-compliance for MySQL that dings it to a lower status than PostgreSQL. As the newer, more compliant versions of MySQL begin to be more available on hosting services, this gap will close. My $0.02 -tim --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
