RPIrates Tutorial: Simple Database Access with R

Remote video URL
Thumbnail

Take some time out from your busy week to talk about database access with R!

In this informal tutorial we'll share some recent experiences using remote and in-memory SQL databases (MySQL and SQLite) to access and analyze near real time, aggregated RPI WiFi data for the RPI SafeCampus and StudySafe applications. As time permits we may also cover our use of ElasticSearch, esp. in our COVID Twitter project, and SPARQL endpoints (Blazegraph, StarDog) as data sources.