My goal is to get rid of SequelPro to access my remote live-databases and do some queries and analyse them locally.
to access my local dev-databases i use DBI/pool
library(DBI)
library(pool)
pool <- dbPool(
drv = RMySQL::MySQL(),
dbname = "dev_playground",
host = "my_host.at",
username = "my_user",
password = "my_password"
)
what i want i something as easy as in sequel pro to remote connect our live database
pool <- dbPool(
drv = RMySQL::MySQL(),
dbname = "live_data",
host = "my_host.at",
username = "my_user",
password = "my_password"
## missing and on my wishlist:
ssh_host = "sftp.my_host.at"
ssh_user = "mr_tunnelrat"
ssh_password= "supasecret_pass123"
ssh_port="1234"
)
is there an goldstandard without doing much pipe() and permanently open connections?