The whole idea of having an ORM is not having ot deal with SQL directly unless necessary. I would try to do it using the ORM first but there's not general rule, each case should be analised individually
On Thu, Oct 17, 2013 at 10:21 AM, Victor Hooi <victorh...@gmail.com> 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+unsubscr...@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/c020f34a-37c0-4259-9251-dd5ccad00968%40googlegroups.com > . > For more options, visit https://groups.google.com/groups/opt_out. > -- 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+unsubscr...@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/CAFWa6tJJFnDvbPLYHjTrYRWnpegEw81GiniBTA4vJ5U5QC1Ynw%40mail.gmail.com. For more options, visit https://groups.google.com/groups/opt_out.
