On 2/21/07, Grupo Django <[EMAIL PROTECTED]> wrote: > Hello, I want to know which of these two databases are prefered by > django. I can choose and I'd like to know if there is some differences > in performance or integration (like foreign keys). > If someone knows a comparative between both of them it would be good, > not only about django integration but about everything.
Objectively, Postgres supports more SQL features than MySQL, and generally has better data integrity features (MySQL's default table type, for example, doesn't "really" enforce foreign key integrity). MySQL tends to be faster with large numbers of small queries, but Postgres tends to do better with more complex things and also seems to scale better on multi-core systems. MySQL, on the other hand, tends to be more widely supported on consumer-level hosting plans, and tends to have more "friendly" administration features (e.g., web-based control panels for managing a database). Subjectively, I prefer Postgres. -- "Bureaucrat Conrad, you are technically correct -- the best kind of correct." --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
