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

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)

slobr

slobr is a Shiny app to read and write files to SQLite databases as flobs. A flob is a special type of BLOB that includes the file extension type.

Installation

To install the latest development version from GitHub

# install.packages("remotes")
remotes::install_github("poissonconsulting/slobr")

Demonstration

library(slobr)
# to run with a demo database
slobr::run_slobr("demo")

# to run with a local database, provide a SQLite Connection
dbname <- "/path/to/db.sqlite"
conn <- DBI::dbConnect(RSQLite::SQLite(), dbname = dbname)
slobr::run_slobr(conn)

App Use

The SQLite Connection provided will be modified by the app. If you want to test the functionality first, we suggest using the demo db provided or create a copy of your own database.

Write files to a BLOB column within a table one cell/file at a time. To create a new BLOB column see the 'other options' link for more buttons.

Read files from individual cells, entire columns or entire tables. These will be provided to you in a nested zipped directory (e.g. 'table/column/file').

Look for the question mark icon to get more instructions within the app.