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

[François Michonneau]

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
>