Saturday, June 26, 2010

Re: New project, debating postgresql or MySQL (Amazon RDS), does it matter to Django?

Hello all,

On Jun 26, 5:46 am, Tomasz Zieliński
<tomasz.zielin...@pyconsultant.eu> wrote:

> Ah, and to save you pulling your hair:
> - create MySQL database with CREATE DATABASE name CHARACTER SET UTF8;
> - set DATABASE_OPTIONS to {"init_command": "SET
> storage_engine=INNODB",}, at least for syncdb. Otherwise your tables
> might be created as MyISAM.
> Both of these are documented:http://docs.djangoproject.com/en/dev/ref/databases/#creating-your-dat...http://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables
> - but it's easy to overlook them

There is nothing wrong with MyISAM tables, if they meet the needs of
your application. In some cases I think they are required; for full
text searching if I recall correctly.

The docs are just pointing out one way to change the storage type for
your tables if needed.

Toodle-loooooooo........
creecode

--
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 django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment