These functions have been deprecated; instead please use tbl()
directly on an DBIConnection
. See https://dbplyr.tidyverse.org/ for
more details.
src_mysql(
dbname,
host = NULL,
port = 0L,
username = "root",
password = "",
...
)src_postgres(
dbname = NULL,
host = NULL,
port = NULL,
user = NULL,
password = NULL,
...
)
src_sqlite(path, create = FALSE)
An S3 object with class src_dbi
, src_sql
, src
.
Database name
Host name and port number of database
for the src, other arguments passed on to the underlying
database connector, DBI::dbConnect()
. For the tbl, included for
compatibility with the generic, but otherwise ignored.
User name and password.
Generally, you should avoid saving username and password in your
scripts as it is easy to accidentally expose valuable credentials.
Instead, retrieve them from environment variables, or use database
specific credential scores. For example, with MySQL you can set up my.cnf
as described in RMySQL::MySQL()
.
Path to SQLite database. You can use the special path ":memory:" to create a temporary in memory database.
if FALSE
, path
must already exist. If
TRUE
, will create a new SQLite3 database at path
if
path
does not exist and connect to the existing database if
path
does exist.