[data-carpentry-discuss] R/SQL integration lesson

[Ethan White]

On Thu, Jan 29, 2015 at 1:29 PM, Ted Hart <edmund.m.hart at gmail.com> wrote:
> Lately I've been doing a lot of database work.  One thing I've found is
that
> the provenance of your work flow with databases is much easier to preserve
> if it's written in R and you interact with the database via RJDBC rather
> than a stand alone database environment.  When I do that I find I have all
> these adhoc queries that I never remember what order to execute them in.
>
> My question is, would this be a  worthwhile lesson for DC?  Or is it too
> advanced? Or  would efforts be better spent working on the existing
> curriculum?  Or would this make a reasonable addendum to the SQL lesson
> (it's actually kind of trivial so it might not be worth it's own lesson).

I agree that this would be a great lesson, and I would be happy to do a
translation to Python.

Ethan

On Thu, Jan 29, 2015 at 11:42 AM, François Michonneau <
francois.michonneau at gmail.com> wrote:

> Hi Ted,
>
>  I think it would be a really valuable addition to the SQL lesson. It
> would have to be taught after the R lesson, but I think it would
> really help tie together these two lessons and motivate more the SQL
> lesson. For people who are already working a little in R, this lesson
> would show them that databases can directly be integrated into their
> workflow.
>
>   Cheers,
>   -- Francois
>
>
>
> On Thu, Jan 29, 2015 at 1:29 PM, Ted Hart <edmund.m.hart at gmail.com> wrote:
> > Lately I've been doing a lot of database work.  One thing I've found is
> that
> > the provenance of your work flow with databases is much easier to
> preserve
> > if it's written in R and you interact with the database via RJDBC rather
> > than a stand alone database environment.  When I do that I find I have
> all
> > these adhoc queries that I never remember what order to execute them in.
> >
> > My question is, would this be a  worthwhile lesson for DC?  Or is it too
> > advanced? Or  would efforts be better spent working on the existing
> > curriculum?  Or would this make a reasonable addendum to the SQL lesson
> > (it's actually kind of trivial so it might not be worth it's own lesson).
> >
> > I welcome some thoughts as I'm happy to take existing code and formalize
> it
> > into a lesson if the group things it's worthwhile.
> >
> > Best,
> > Ted
> >
> >
> > _______________________________________________
> > dc-discuss mailing list
> > dc-discuss at lists.idyll.org
> > http://lists.idyll.org/listinfo/dc-discuss
> >
>
> _______________________________________________
> dc-discuss mailing list
> dc-discuss at lists.idyll.org
> http://lists.idyll.org/listinfo/dc-discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.idyll.org/pipermail/dc-discuss/attachments/20150202/e65de2c1/attachment.htm>