Create a connection to a DBMS
Connect to a DBMS going through the appropriate authorization procedure. Some implementations may allow you to have multiple connections open, so you may invoke this function repeatedly assigning its output to different objects. The authorization mechanism is left unspecified, so check the documentation of individual drivers for details.
- an object that inherits from
DBIDriver, or an existing
DBIConnectionobject (in order to clone an existing connection).
- authorization arguments needed by the DBMS instance; these
port, etc. For details see the appropriate
Each driver will define what other arguments are required, e.g.,
"dbname" for the database name,
An object that extends
DBIConnectionin a database-specific manner. For instance
dbConnect(RMySQL::MySQL())produces an object of class
MySQLConnection. This object is used to direct commands to the database engine.
dbDisconnect to disconnect from a database.
# SQLite only needs a path to the database. Other database drivers # will require more details (like username, password, host, port etc) con <- dbConnect(RSQLite::SQLite(), ":memory:") con dbListTables(con) dbDisconnect(con)