Learn R Programming

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

DBI (version 0.3.1)

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

696,767

Version

0.3.1

License

LGPL (>= 2)

Issues

Pull Requests

Stars

Forks

Repository

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

Maintainer

Hadley Wickham

Last Published

September 24th, 2014

Functions in DBI (0.3.1)

Execute a statement on a given database connection.

Clear a result set.

Does a table exist?

Has the operation completed?

Get the statement associated with a result set

dbListConnections

List currently open connections.

Is this DBMS object still valid?

Copy data frames to and from database tables.

dbGetRowsAffected

The number of rows affected by data modifying query.

dbGetDBIVersion

Determine the current version of the package.

A list of all pending results.

Get DBMS metadata.

Create a connection to a DBMS.

Determine the SQL data type of an object.

Make R identifiers into legal SQL identifiers.

Begin/commit/rollback SQL transactions

DBIResult-class

DBIResult class.

Information about result types.

Fetch records from a previously executed query.

Send query, retrieve results and then clear result set.

DBIDriver-class

DBIDriver class.

DBIObject-class

DBIObject class.

print.list.pairs

Print a list of pairs.

dbSetDataMappings

Set data mappings between an DBMS and R.

Load and unload database drivers.

Disconnect (close) a connection

DBIConnection-class

DBIConnection class.

The number of rows fetched so far.

Call an SQL stored procedure

List remote tables.

Remove a table from the database.

Get DBMS exceptions.

List field names of a remote table.

dbiCheckCompliance

Check a driver for compliance with DBI.