An R package for working with SQLite databases encrypted in SQLCipher. Does NOT use the DBI backend. Is NOT a drop-in replacement for RSQLite.
devtools::install_github("CoryMcCartan/RSQLCipher")
RSQLCipher provides the load_table
and execute
functions.
library(RSQLCipher)
library(tidyverse)
# load the database table
# will be prompted for authentication key the first time
d = load_table("database.db", "customers")
summarized = d %>%
group_by(city) %>%
summarize(count=n()) %>%
execute
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.