Ryan Peek: Intro to SQLite Databases in R

Ryan gave an awesome introduction to SQLite databases


This tutorial will cover how you can utilize SQlite databases in R. They are flexible, provide a great way to store all your tables/spreadsheets in a portable format, and work on most any operating system. I’ll go over the basics of how to create, access, and read/write to a SQlite database in R, using the dbplyr and RSQLite packages.

Video of Presentation

A recorded video of the presentation is available here:


Materials used in the presentation can be viewed at this link