DBI v0.3.0


Monthly downloads



by Hadley Wickham

R Database Interface

A database interface (DBI) 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 in DBI

Name Description
DBIConnection-class DBIConnection class.
dbGetRowCount The number of rows fetched so far.
dbGetDBIVersion Determine the current version of the package.
dbDisconnect Disconnect (close) a connection
SQL SQL quoting.
dbListTables List remote tables.
dbReadTable Copy data frames to and from database tables.
DBIDriver-class DBIDriver class.
dbExistsTable Does a table exist?
dbColumnInfo Information about result types.
dbConnect Create a connection to a DBMS.
dbDriver Load and unload database drivers.
dbGetRowsAffected The number of rows affected by data modifying query.
dbIsValid Is this DBMS object still valid?
dbHasCompleted Has the operation completed?
dbGetInfo Get DBMS metadata.
DBIObject-class DBIObject class.
dbCallProc Call an SQL stored procedure
dbRemoveTable Remove a table from the database.
transactions Begin/commit/rollback SQL transactions
dbDataType Determine the SQL data type of an object.
dbSendQuery Execute a statement on a given database connection.
dbGetQuery Send query, retrieve results and then clear result set.
print.list.pairs Print a list of pairs.
dbSetDataMappings Set data mappings between an DBMS and R.
dbGetStatement Get the statement associated with a result set
dbListFields List field names of a remote table.
dbFetch Fetch records from a previously executed query.
DBIResult-class DBIResult class.
dbClearResult Clear a result set.
dbListConnections List currently open connections.
dbListResults A list of all pending results.
dbGetException Get DBMS exceptions.
make.db.names Make R identifiers into legal SQL identifiers.
dbiCheckCompliance Check a driver for compliance with DBI.
No Results!

Last month downloads


License LGPL (>= 2)
URL https://github.com/rstats-db/DBI
BugReports https://github.com/rstats-db/DBI/issues
Collate 'DBObject.R' 'DBConnection.R' 'DBDriver.R' 'DBResult.R' 'compliance.R' 'keywords.R' 'quote.R' 'util.R'
NeedsCompilation no
Packaged 2014-09-02 23:05:32 UTC; ligges
Repository CRAN
Date/Publication 2014-09-03 01:05:44

Include our badge in your README