Hi Tracy,<br><br>Sure, I will do it with the existing biology data set for continuity. Thanks for offering to translate with python Ethan. What's the jdbc library you use with Python? With the JayDeBeApi? <div><br></div><div>T<br><br><div class="gmail_quote">On Mon Feb 02 2015 at 10:30:05 AM Tracy Teal <<a href="mailto:tkteal@datacarpentry.org">tkteal@datacarpentry.org</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="color:rgb(0,0,0);background-color:rgb(255,255,255)" bgcolor="#FFFFFF" text="#000000"><br>
<blockquote style="border:0px none" type="cite"><div style="margin:30px 25px 10px 25px"><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 src="cid:part1.09080503.01050905@datacarpentry.org" name="msg-f:1492020684172257442_compose-unknown-contact.jpg" height="25px" width="25px"></div> <div style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
        <a href="mailto:ethan@weecology.org" style="color:#737f92!important;padding-right:6px;font-weight:bold;text-decoration:none!important" target="_blank">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"><div dir="ltr"><div><span>On Thu, Jan 29, 2015 at 1:29 PM, Ted
Hart <<a href="mailto:edmund.m.hart@gmail.com" target="_blank">edmund.m.hart@gmail.com</a>>
wrote:<br>
</span><div><div>> 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 href="https://github.com/datacarpentry/datacarpentry/tree/master/data/biology" target="_blank">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" type="cite"><div style="color:#888888;margin-left:24px;margin-right:24px">
<div dir="ltr">
<div><br></div>
Ethan<br></div>
<div class="gmail_extra"><br><br></div>
<div>_______________________________________________<br>dc-discuss
mailing list<br><a href="mailto:dc-discuss@lists.idyll.org" target="_blank">dc-discuss@lists.idyll.org</a><br><a href="http://lists.idyll.org/listinfo/dc-discuss" target="_blank">http://lists.idyll.org/listinfo/dc-discuss</a><br></div></div>
<div style="margin:30px 25px 10px 25px"><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 src="cid:part1.09080503.01050905@datacarpentry.org" name="msg-f:1492020684172257442_compose-unknown-contact.jpg" height="25px" width="25px"></div> <div style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
        <a href="mailto:francois.michonneau@gmail.com" style="color:#737f92!important;padding-right:6px;font-weight:bold;text-decoration:none!important" target="_blank">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"><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 href="mailto:dc-discuss@lists.idyll.org" target="_blank">dc-discuss@lists.idyll.org</a><br><a href="http://lists.idyll.org/listinfo/dc-discuss" target="_blank">http://lists.idyll.org/listinfo/dc-discuss</a><br></div></div>
<div style="margin:30px 25px 10px 25px"><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 src="cid:part1.09080503.01050905@datacarpentry.org" name="msg-f:1492020684172257442_compose-unknown-contact.jpg" height="25px" width="25px"></div> <div style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
        <a href="mailto:edmund.m.hart@gmail.com" style="color:#737f92!important;padding-right:6px;font-weight:bold;text-decoration:none!important" target="_blank">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">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 href="mailto:dc-discuss@lists.idyll.org" target="_blank">dc-discuss@lists.idyll.org</a><br><a href="http://lists.idyll.org/listinfo/dc-discuss" target="_blank">http://lists.idyll.org/listinfo/dc-discuss</a><br></div></div></blockquote>
</div>
______________________________<u></u>_________________<br>
dc-discuss mailing list<br>
<a href="mailto:dc-discuss@lists.idyll.org" target="_blank">dc-discuss@lists.idyll.org</a><br>
<a href="http://lists.idyll.org/listinfo/dc-discuss" target="_blank">http://lists.idyll.org/<u></u>listinfo/dc-discuss</a><br>
</blockquote></div></div>