Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

DBI

R Database Interface

A database interface definition for communication between R and relational database management systems. All classes in this package are virtual and need to be extended by the various R/DBMS implementations.

Functions (59)

ANSI

A dummy DBI connector that simulates ANSI-SQL compliance

DBI-package

DBI: R Database Interface

DBIConnection-class

DBIConnection class

DBIConnector-class

DBIConnector class

DBIDriver-class

DBIDriver class

DBIObject-class

DBIObject class

DBIResult-class

DBIResult class

Refer to a table nested in a hierarchy (e.g. within a schema)

SQL

SQL quoting

dbAppendTable

Insert rows into a table

dbBind

Bind values to a parameterized/prepared statement

dbCallProc

Call an SQL stored procedure

dbCanConnect

Check if a connection to a DBMS can be established

dbClearResult

Clear a result set

dbColumnInfo

Information about result types

dbConnect

Create a connection to a DBMS

dbCreateTable

Create a table in the database

dbDataType

Determine the SQL data type of an object

dbDisconnect

Disconnect (close) a connection

dbDriver

Load and unload database drivers

dbExecute

Execute an update statement, query number of rows affected, and then close result set

dbExistsTable

Does a table exist?

dbFetch

Fetch records from a previously executed query

dbGetConnectArgs

Get connection arguments

dbGetDBIVersion

Determine the current version of the package.

dbGetException

Get DBMS exceptions

dbGetInfo

Get DBMS metadata

dbGetQuery

Send query, retrieve results and then clear result set

dbGetRowCount

The number of rows fetched so far

dbGetRowsAffected

The number of rows affected

dbGetStatement

Get the statement associated with a result set

dbHasCompleted

Completion status

dbIsReadOnly

Is this DBMS object read only?

dbIsValid

Is this DBMS object still valid?

dbListConnections

List currently open connections

dbListFields

List field names of a remote table

dbListObjects

List remote objects

dbListResults

A list of all pending results

dbListTables

List remote tables

dbQuoteIdentifier

Quote identifiers

dbQuoteLiteral

Quote literal values

dbQuoteString

Quote literal strings

dbReadTable

Copy data frames from database tables

dbRemoveTable

Remove a table from the database

dbSendQuery

Execute a query on a given database connection

dbSendStatement

Execute a data manipulation statement on a given database connection

dbSetDataMappings

Set data mappings between an DBMS and R.

dbUnquoteIdentifier

Unquote identifiers

dbWithTransaction

Self-contained SQL transactions

dbWriteTable

Copy data frames to database tables

hidden_aliases

Internal page for hidden aliases

make.db.names

Make R identifiers into legal SQL identifiers

rownames

Convert row names back and forth between columns

sqlAppendTable

Compose query to insert rows into a table

sqlCreateTable

Compose query to create a simple table

sqlData

Convert a data frame into form suitable for upload to an SQL database

sqlInterpolate

Safely interpolate values into an SQL string

sqlParseVariables

Parse interpolated variables from SQL.

transactions

Begin/commit/rollback SQL transactions

DBI

R Database Interface

v1.1.1

LGPL (>= 2.1)

Authors

R Special Interest Group on Databases (R-SIG-DB) [aut], Hadley Wickham [aut], Kirill Müller [aut, cre] (<https://orcid.org/0000-0002-1416-3412>), R Consortium [fnd]

Initial release

2021-01-04

DBI

Functions (59)

DBI

We don't support your browser anymore