Re: Loading data from Django into RedShift - ORM vs SQL?

Hi,

Does anyone here have experience in using the django-redshift ORM available in: https://github.com/binarydud/django-redshift

in a django web app? If so could you share it with us?

Is it robust? Scalably efficient?

Many thanks.

On Thursday, October 17, 2013 9:21:08 AM UTC+2, Victor Hooi wrote:

Hi,

We have a Django eCommerce site, from where we want to load transactional data into Amazon RedShift (i.e. basically ETL).

This would probably be a batch load run either once a day, or at intervals throughout the day.

(I'm also curious about whether it's possible to stream the data in, but I don't think that will work well with RedShift).

My question is regarding how we should be extracting the data - we can either hook directly into the Django ORM, or just use SQL by hand.

What are people's experiences with either approach? Any thoughts on pros/cons of either?

Cheers,

Victor

--
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/171752ed-c5df-45b4-ab88-a0ae2c194a60%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.