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.
To install the latest development version from GitHub
# install.packages("remotes")
remotes::install_github("poissonconsulting/slobr")
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)
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.
Please report any issues.
Pull requests are always welcome.
Please note that the slobr project is released with a Contributor Code of Conduct. By contributing to this project, you agree to abide by its terms.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.