src_dbi
Source for database backends
Description
![[Deprecated]](../help/figures/lifecycle-deprecated.svg)
These functions have been deprecated; instead please use tbl()
directly on an DBIConnection. See https://dbplyr.tidyverse.org/ for
more details.
Usage
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)
Arguments
dbname |
Database name |
host, port |
Host name and port number of database |
... |
for the src, other arguments passed on to the underlying
database connector, |
user, username, password |
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 |
path |
Path to SQLite database. You can use the special path ":memory:" to create a temporary in memory database. |
create |
if |
Value
An S3 object with class src_dbi, src_sql, src.
Examples
if (require(dbplyr, quietly = TRUE)) {
con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
copy_to(con, mtcars)
# To retrieve a single table from a source, use `tbl()`
mtcars <- con %>% tbl("mtcars")
mtcars
# You can also use pass raw SQL if you want a more sophisticated query
con %>% tbl(sql("SELECT * FROM mtcars WHERE cyl == 8"))
}