<div dir="ltr"><div><span class="im">On Thu, Jan 29, 2015 at 1:29 PM, Ted Hart <<a 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><br></div>Ethan<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jan 29, 2015 at 11:42 AM, François Michonneau <span dir="ltr"><<a href="mailto:francois.michonneau@gmail.com" target="_blank">francois.michonneau@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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>
<span class="im HOEnZb"><br>
<br>
<br>
On Thu, Jan 29, 2015 at 1:29 PM, Ted Hart <<a href="mailto:edmund.m.hart@gmail.com">edmund.m.hart@gmail.com</a>> wrote:<br>
</span><div class="HOEnZb"><div class="h5">> 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).<br>
><br>
> I welcome some thoughts as I'm happy to take existing code and formalize it<br>
> into a lesson if the group things it's worthwhile.<br>
><br>
> Best,<br>
> Ted<br>
><br>
><br>
</div></div><div class="HOEnZb"><div class="h5">> _______________________________________________<br>
> dc-discuss mailing list<br>
> <a href="mailto:dc-discuss@lists.idyll.org">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>
><br>
<br>
_______________________________________________<br>
dc-discuss mailing list<br>
<a href="mailto:dc-discuss@lists.idyll.org">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><br></div>