R + Databases

Do you use R to connect to databases? Do you want to? Or maybe you're just database-curious!

R-Ladies PDX Member Sophie Yang has been involved with a project group that sought to improve on a database + R tutorial from CascadiaR this summer. We will be testing out their improved tutorial materials, giving them feedback based on our experiences, and maybe even learning something new about databases & R in the process!

Sophie has provided the following setup instructions:

Important note for Windows users: Windows-10 Pro requires that Hyper-V be turned for Docker to Work which requires a lengthy reboot to perform the Hyper-V installation. If you have any Oracle VM's running, they will not run with Hyper-V installed. One should be able to uninstall Hyper-V which requires another lengthy reboot and have your Oracle VM's work again. We have not tested this process.

1. Install Docker using these instructions: https://smithjd.github.io/sql-pet/setup-instructions-00.html#docker

2. Download the repository: https://github.com/smithjd/sql-pet

3. Install our helper package with devtools::install_github("smithjd/sqlpetr")

4. Browse the book in advance (if you want): https://smithjd.github.io/sql-pet/ (It's very rough! Consider helping us with edits and suggestions!)

Sophie & others will be available a half hour early (at least) to help folks with set up. If this seems a little daunting, don't worry! We are a friendly & supportive group! The goal of this Meetup is to help others become better teachers in addition to learning something new for ourselves.

We will meet in the OHSU Robertson Life Sciences Building (RSLB, formerly known as CLSB), Room 1S040. It is on the ground floor, kind of hidden at the back of the South Elevator Bank. I've uploaded a photo of the map.