Using Django Multiple Databases With Redshift
I am trying to use an Django multiple database configuration with MYSQL as my default database and redshift as my analytics database. My configuration looks sometime like this: DAT
Solution 1:
The specific problem is: Django wants to create a migration-management table with a serial primary key to track migration history. Redshift doesn't support that.
The more general problem with the approach, though, is that you don't really want Django-style migrations on a Redshift database (see stuff like How to change table schema after created in Redshift?). Redshift is meant for huge databases and changing it's schema can be a heavyweight job.
So, the answer is: don't use Django migrations with redshift. Syncdb might be ok, to initialize your tables, but after that you will need to manage the schema manually. Don't create a migrations__init__.py file in an app whose models are intended for Redshift.
Related/duplicate questions here:
Post a Comment for "Using Django Multiple Databases With Redshift"