In poissonconsulting/slobr: An app to read and write files to SQLite databases

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>"
)

library(slobr)

# For this tutorial we will use a demo database that is contained within the package
slobr::run_slobr("demo")

The app will open in a browser window.

Adding flobs to a database

1 - Under 'Table Selection', choose 'Table 1'

knitr::include_graphics(paste0(getwd(), "/figures/tut-1.png"))

2 - Select the cell in the table that you would like to populate with a flob, then click 'write cell'

knitr::include_graphics(paste0(getwd(), "/figures/tut-2.png"))

3 - Choose a file and once slobr has indicated that the upload is complete, click 'write'

knitr::include_graphics(paste0(getwd(), "/figures/tut-3.png"))

Adding a flob column to a database table

In some cases, you may need to add a new column in which to store flobs. Take for example the 'RwsData' table, which does not yet have a flob column.

1 - Click 'other options', then 'add column',

knitr::include_graphics(paste0(getwd(), "/figures/tut-4.png"))

2 - Give the new column a name and click 'add column',

knitr::include_graphics(paste0(getwd(), "/figures/tut-5.png"))

3 - You now have a flob column and can populate it as usual.

knitr::include_graphics(paste0(getwd(), "/figures/tut-6.png"))

poissonconsulting/slobr documentation built on June 25, 2022, 4:40 p.m.