Database within the Art Viewer

Exercise 1


This page is under construction and will be updated as the materials are posted online.

The application contained in the ex-1/app.R is the same as what we built in the reactivity code-along activity. But now it is time to pivot our backend to leverage a robust database stored as a SQLite file.


Copy the SQLite database file to the data directory for this application by executing the following snippet in the R console:

fs::file_copy("materials/db/db_small.sqlite", "materials/d1-05-db-api/exercise-1/data/db_small.sqlite)

Here are the tasks to complete for this exercise:


You can obtain the user name by using the function get_user() stored in the R/get_user.R script.