Work with databases directly from R - special guest speaker Amy

Hey everyone,

This is a very promising meet up where Amy will tell us more about how to connect directly to a database from within R!
Being able to work with databases is a major requirement for anyone that wants to work with large amounts of data. This is also a major skill data scientist and data analysts at all levels need to develop.
So don't miss this opportunity and join us to learn more from Amy.

We're looking forward to seeing you there!

Your R-Ladies organizers

UPDATE: Here is some more info from Amy on how we can get a head start before the meeting. Please read the information below and try to install the necessary software / packages ahead of time. Thanks!

R packages:
stringr
DBI
RSQLite

Database software installed on the laptop:
SQLite
This software is sometimes called SQLite and sometimes called SQLite3. For the sake of this demo, the difference does not matter at all.

SQLite on a Mac:
Your computer might have come with SQLite installed. Open up a Terminal window and type:
which sqlite3
If you see something like /usr/bin/sqlite3, then you are all set. If it doesn’t say anything, then see the Homebrew instructions below.

If you do not have SQLite, you can install it with Homebrew:
Point your web browser at: brew.sh
Follow the directions for installing Homebrew
At the command line, type: brew install sqlite
If that fails, try: brew install sqlite3

Also, the files for the tutorial are now available on GitHub at https://github.com/rladies-san-diego/2019_06_27_Amy_databases

Thanks!

PS: We are meeting at the Salk Institute this month. The plan is to meet at the main gate at 6:30pm so we can go in together. If you arrive late, please let me know in the comments as the doors will be locked and I'll have to let you in. Thanks!