Learn R Programming

⚠️There's a newer version (1.2.2) of this package.Take me there.

DBI (version 0.3.0)

R Database Interface

Description

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.

Copy Link

Version

Install

install.packages('DBI')

Monthly Downloads

571,667

Version

0.3.0

License

LGPL (>= 2)

Issues

Pull Requests

Stars

Forks

Repository

https://github.com/rstats-db/DBI

Maintainer

Hadley Wickham

Last Published

September 2nd, 2014

Functions in DBI (0.3.0)

DBIConnection-class

DBIConnection class.

The number of rows fetched so far.

dbGetDBIVersion

Determine the current version of the package.

Disconnect (close) a connection

List remote tables.

Copy data frames to and from database tables.

DBIDriver-class

DBIDriver class.

Does a table exist?

Information about result types.

Create a connection to a DBMS.

Load and unload database drivers.

dbGetRowsAffected

The number of rows affected by data modifying query.

Is this DBMS object still valid?

Has the operation completed?

Get DBMS metadata.

DBIObject-class

DBIObject class.

Call an SQL stored procedure

Remove a table from the database.

Begin/commit/rollback SQL transactions

Determine the SQL data type of an object.

Execute a statement on a given database connection.

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.

Get the statement associated with a result set

List field names of a remote table.

Fetch records from a previously executed query.

DBIResult-class

DBIResult class.

Clear a result set.

dbListConnections

List currently open connections.

A list of all pending results.

Get DBMS exceptions.

Make R identifiers into legal SQL identifiers.

dbiCheckCompliance

Check a driver for compliance with DBI.