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