inst/doc/databases.R

In shiny.telemetry: 'Shiny' App Usage Telemetry

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

## ----eval=FALSE---------------------------------------------------------------
#  Sys.setenv("POSTGRES_USER" = "postgres", "POSTGRES_PASS" = "mysecretpassword")
#  data_storage <- DataStoragePostgreSQL$new(
#    user = Sys.getenv("POSTGRES_USER"),
#    password = Sys.getenv("POSTGRES_PASS"),
#    hostname = "127.0.0.1",
#    port = 5432,
#    dbname = "shiny_telemetry",
#    driver = "RPostgreSQL"
#  )

## ----eval=FALSE---------------------------------------------------------------
#  Sys.setenv("MARIADB_USER" = "mariadb", "MARIADB_PASS" = "mysecretpassword")
#  data_storage <- DataStorageMariaDB$new(
#    user = Sys.getenv("MARIADB_USER"),
#    password = Sys.getenv("MARIADB_PASS"),
#    hostname = "127.0.0.1",
#    port = 3306,
#    dbname = "shiny_telemetry"
#  )

## ----eval=FALSE---------------------------------------------------------------
#  Sys.setenv(MSSQL_USER = "sa", MSSQL_PASS = "my-Secr3t_Password")
#  data_storage <- DataStorageMSSQLServer$new(
#    user = Sys.getenv("MSSQL_USER"),
#    password = Sys.getenv("MSSQL_PASS"),
#    hostname = "127.0.0.1",
#    port = 1433,
#    dbname = "my_db",
#    driver = "ODBC Driver 18 for SQL Server",
#    trust_server_certificate = "YES"
#  )

## ----eval=FALSE---------------------------------------------------------------
#  data_storage <- DataStorageMongoDB$new(
#    host = "localhost",
#    dbname = "test",
#    authdb = NULL,
#    options = NULL,
#    ssl_options = mongolite::ssl_options()
#  )
#  
#  To run MongoDB in a container locally, you can use the following Docker compose file: [`inst/examples/mssql/docker-compose.yml`](https://github.com/Appsilon/shiny.telemetry/blob/main/inst/examples/mongodb/docker-compose.yml).

## ----eval=FALSE---------------------------------------------------------------
#  data_storage <- DataStorageSQLite$new(
#    db_path = "telemetry.sqlite"
#  )