Re: Using AWS Redshift database Django 1.6

Wow, redshift lets you save quite a bit of data.
It looks like someone started in on a redshift backend, I found something on github (https://github.com/binarydud/django-redshift)
It appears to be unmaintained, and maybe not even complete, but you might get some idea's of where work needs to be done from it.

Kirby

On Thursday, May 29, 2014 9:13:55 AM UTC-5, jpk wrote:

Greetings,

I'm attempting to set up a django project using amazon redshift as the database backend.  I started a fresh 1.6.5 project and set up the database portion of settings.py to use the redshift cluster. With just the default apps (admin, auth, contenttypes, sessions, messages, and staticfiles), I ran syncdb and got this: https://dpaste.de/y98N.  Compared to vanilla postgre, redshift doesn't support some things, including some constraints, which is what's making syncdb blow up.

What worries me in that backtrace is, the table creation sql that has the offending constraint in it is being generated in commands/syncdb.py, so that's before we even get to the postgresql_psycopg2 backend code, right?  So hacking on the postgres backend to make it jive with redshift wouldn't help, here.  (Correct me if I'm wrong!)

Anyway, what wisdom can you share?  What's the best way to approach this?  Is trying to get this to work even a good idea?  Any guidance would be greatly appreciated.


Thanks!
jpk

--
john p. kiffmeyer

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/8bd4e6b5-42c5-4779-86af-cb04b708540d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.