Hi Malcolm, Tomas, Malcolm Tredinnick wrote: > Hi Thomas, > > On Thu, 2006-07-06 at 23:17 -0700, Thomas Ashelford 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.
I go also with: whatever you used to, use it. >> I've just moved from DreamHost to Webfaction to get the advantage of >> using mod_python instead of fcgi. Already the advantages of mod_python >> are clear (it's basically less flaky). But I now have the choice of 2 >> dB platforms and I'm wondering if there are any strong reasons to >> switch to PostgreSQL. So far I can only see a potential negative - I >> may want to use fulltext indexing in the future, and I believe this is >> not available on PostgreSQL. If you are using FULLTEXT indices, you will need MyISAM. MyISAM doesn't support transactions. This you need to consider too. You can mix storage engines of course. > I would add, for most projects, it's not a really clear cut case. Django > hides the SQL oddities for you, so there's not going to much difference > there (using MySQL 5 with transaction support is kind of assumed here, > although even that's not clear cut in some cases). MySQL supports transcations since 3.23 (which is ages ago). James Bennett did mention it, but I'll repeat: you need to use InnoDB storage engine to get transactional support. You can mix non-transactional (like MyISAM) and transaction (InnoDB) storage engines, but when a rollback occures the MyISAM 'commit' can't be rolled back. MySQL Cluster also support transactions (but only with one isolation level). Cheers, Geert -- Geert Vanderkelen, Support Engineer MySQL GmbH, Germany, www.mysql.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
