This virtual class encapsulates the connection to a DBMS, and it provides access to dynamic queries, result sets, DBMS session management (transactions), etc.

Implementation note

Individual drivers are free to implement single or multiple simultaneous connections.

See also


con <- dbConnect(RSQLite::SQLite(), ":memory:") con
#> <SQLiteConnection> #> Path: :memory: #> Extensions: TRUE
dbDisconnect(con) if (FALSE) { con <- dbConnect(RPostgreSQL::PostgreSQL(), "username", "passsword") con dbDisconnect(con) }