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

DBI (version 0.2-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

711,123

Version

0.2-0

License

GPL (version 2 or later)

Maintainer

David James

Last Published

February 16th, 2024

Functions in DBI (0.2-0)

dbConnect

Create a connection to a DBMS

DBIResult-class

Class DBIResult

DBI-internal

Version 4 meta-objects

dbCallProc

Call an SQL stored procedure

print.list.pairs

Support functions

dbDataType

Determine the SQL Data Type of an S object

fetch

Fetch records from a previously executed query

make.db.names

Make R/Splus identifiers into legal SQL identifiers

dbCommit

DBMS Transaction Management

dbListTables

List items from a remote DBMS and from objects that implement the database interface DBI.

DBIConnection-class

Class DBIConnection

dbSetDataMappings

Set data mappings between an DBMS and R/Splus

dbDriver

Database Interface (DBI) Classes and drivers

dbGetInfo

Database interface meta-data

DBIDriver-class

Class DBIDriver

dbSendQuery

Execute a statement on a given database connection

DBIObject-class

Class DBIObject

dbReadTable

Convenience functions for Importing/Exporting DBMS tables