Hi James, Thomas, James Bennett wrote: > On 7/7/06, Thomas Ashelford <[EMAIL PROTECTED]> wrote: >> I keep reading that PostgreSQL is the preferred database for use with >> Django, but I'm wondering if anyone can explain what its concrete >> advantages are. > > The advantages of Postgres are mostly to do with its better support of > SQL (you have more options for specifying constraints, writing > functions and views in the database -- not to be confused with Django > views, which are something very different -- and so on) and more > robust integrity features; where with MySQL transaction support is > only available if you choose the correct storage engine, Postgres > gives you transactions automatically.
Note that when starting new projects and choosing MySQL, you better go MySQL 5.0 directly (or even 5.1 if you want to test new features there..). Note that there have been some important features added to MySQL 5.0: - More standard SQL - Stored routines (or procedures) - Views, triggers - Etc, Etc,.. Like James mentions, you need InnoDB for transactional support (which has been in MySQL since 3.23) and integrity checking. Though, foreign keys support might come in the future over all storage engines.. One of the big advantages of MySQL is ease of use and a choice when it comes to how you store data. For example: if you need fast reads and less updates, make your table MyISAM (you can even compress it making it smaller and faster!). If you need high availability of your data, you can go MySQL Cluster. Need a data to /dev/null, use the blackhole engine! ;) Anyway, whatever you choose, choose the one you are most comfortable with! Cheers, Geert -- Geert Vanderkelen, Support Engineer MySQL GmbH, Germany, www.mysql.com Hauptsitz: MySQL GmbH, Radlkoferstr. 2, D-81373 München Geschäftsführer: Hans von Bell, Kaj Arnö - HRB München 162140 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
