<html><head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head><body bgcolor="#FFFFFF" text="#000000"><br>
<blockquote style="border: 0px none;"
cite="mid:CAJbPz5PLBrKM7WSnx4NHG9ArePu7OfD7B-BFhTA=_eBBfUS51g@mail.gmail.com"
type="cite">
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="ethan@weecology.org" photoname="Ethan White"
src="cid:part1.02090304.03080600@datacarpentry.org"
name="compose-unknown-contact.jpg" height="25px" width="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true" href="mailto:ethan@weecology.org"
style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Ethan White</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">February 2, 2015
at 1:16 PM</span></font></div></div></div>
<div style="color: rgb(136, 136, 136); margin-left: 24px;
margin-right: 24px;" __pbrmquotes="true" class="__pbConvBody"><div
dir="ltr"><div><span class="im">On Thu, Jan 29, 2015 at 1:29 PM, Ted
Hart <<a moz-do-not-send="true" href="mailto:edmund.m.hart@gmail.com">edmund.m.hart@gmail.com</a>>
wrote:<br>
</span><div class=""><div class="im">> Lately I've been doing a lot
of database work. One thing I've found is that<br>
> the provenance of your work flow with databases is much easier to
preserve<br>
> if it's written in R and you interact with the database via RJDBC
rather<br>
> than a stand alone database environment. When I do that I find I
have all<br>
> these adhoc queries that I never remember what order to execute
them in.<br>
><br>
> My question is, would this be a worthwhile lesson for DC? Or is
it too<br>
> advanced? Or would efforts be better spent working on the existing<br>
> curriculum? Or would this make a reasonable addendum to the SQL
lesson<br>
> (it's actually kind of trivial so it might not be worth it's own
lesson).</div></div><br>I agree that this would be a great lesson, and I
would be happy to do a translation to Python.<br></div></div></div>
</blockquote>
We're interested and working on more advanced content, so I agree this
would be great. And thanks Ethan for offering to do the translation. It
should be done with the current biology dataset
(<a class="moz-txt-link-freetext" href="https://github.com/datacarpentry/datacarpentry/tree/master/data/biology">https://github.com/datacarpentry/datacarpentry/tree/master/data/biology</a>)
to build on the existing lessons. Will that data work for the lesson
you have in mind? <br>
<br>
Thanks!<br>
-Tracy<br>
<blockquote style="border: 0px none;"
cite="mid:CAJbPz5PLBrKM7WSnx4NHG9ArePu7OfD7B-BFhTA=_eBBfUS51g@mail.gmail.com"
type="cite">
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody">
<div dir="ltr">
<div><br></div>
Ethan<br></div>
<div class="gmail_extra"><br><br></div>
<div>_______________________________________________<br>dc-discuss
mailing list<br><a class="moz-txt-link-abbreviated" href="mailto:dc-discuss@lists.idyll.org">dc-discuss@lists.idyll.org</a><br><a class="moz-txt-link-freetext" href="http://lists.idyll.org/listinfo/dc-discuss">http://lists.idyll.org/listinfo/dc-discuss</a><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="francois.michonneau@gmail.com" photoname="François
Michonneau" src="cid:part1.02090304.03080600@datacarpentry.org"
name="compose-unknown-contact.jpg" height="25px" width="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true"
href="mailto:francois.michonneau@gmail.com" style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">François Michonneau</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">January 29, 2015
at 1:42 PM</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div>Hi Ted,<br><br> I think it
would be a really valuable addition to the SQL lesson. It<br>would have
to be taught after the R lesson, but I think it would<br>really help
tie together these two lessons and motivate more the SQL<br>lesson. For
people who are already working a little in R, this lesson<br>would show
them that databases can directly be integrated into their<br>workflow.<br><br>
Cheers,<br> -- Francois<br><br><br></div><div><!----><br>_______________________________________________<br>dc-discuss
mailing list<br><a class="moz-txt-link-abbreviated" href="mailto:dc-discuss@lists.idyll.org">dc-discuss@lists.idyll.org</a><br><a class="moz-txt-link-freetext" href="http://lists.idyll.org/listinfo/dc-discuss">http://lists.idyll.org/listinfo/dc-discuss</a><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="edmund.m.hart@gmail.com" photoname="Ted Hart"
src="cid:part1.02090304.03080600@datacarpentry.org"
name="compose-unknown-contact.jpg" height="25px" width="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true" href="mailto:edmund.m.hart@gmail.com"
style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Ted Hart</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">January 29, 2015
at 1:29 PM</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody">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. <div><br></div><div>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). </div><div><br></div><div>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.</div><div><br></div><div>Best,</div><div>Ted</div><div><br></div>
<div>_______________________________________________<br>dc-discuss
mailing list<br><a class="moz-txt-link-abbreviated" href="mailto:dc-discuss@lists.idyll.org">dc-discuss@lists.idyll.org</a><br><a class="moz-txt-link-freetext" href="http://lists.idyll.org/listinfo/dc-discuss">http://lists.idyll.org/listinfo/dc-discuss</a><br></div></div>
</blockquote>
</body></html>