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

[Karen Cranston]

In the very first DC workshop at NESCent, the final lesson (done by Hilmar)
was pipeline that combined data access in SQL with Python analysis (albeit
simply calling sqlite and python from bash, not using sqlite from within
python). I think this could be a useful end-of-day-2 lesson, particularly
if it emphasized workflow reproducibility.

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
>
>


-- 
~~~~~~~~~~~~~~~~~~~~~~~
karen.cranston at gmail.com
@kcranstn
~~~~~~~~~~~~~~~~~~~~~~~
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.idyll.org/pipermail/dc-discuss/attachments/20150129/f94035f2/attachment.htm>