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

DBI (version 0.1-2)

R/Splus Database Interface

Description

A common database interface (DBI) class and method definitions. All classes in this package are virtual and need to be extended by the various DBMS implementatios. See DBI.RODBC, DBI.RPgSQL for examples of simple DBI front-ends to those existing packages.

Copy Link

Version

Install

install.packages('DBI')

Monthly Downloads

696,767

Version

0.1-2

License

GPL (version 2 or later)

Maintainer

David James

Last Published

February 16th, 2024

Functions in DBI (0.1-2)

fetch

Fetch records from a previously executed query
DBI-internal

Version 4 meta-objects
make.db.names

Make R/S identifiers into legal SQL identifiers
dbGetInfo

Database interface meta-data
dbSendQuery

Execute a statement on a given database connection
dbDataType

Determine the SQL Data Type of an S object
dbCommit

DBMS Transaction Management
dbDriver

Database Interface (DBI) Classes and drivers
print.list.pairs

Support functions
dbCallProc

Call an SQL stored procedure
dbListTables

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

Create a connection to a DBMS
dbReadTable

Convenience functions for Importing/Exporting DBMS tables
dbSetDataMappings

Set data mappings between an DBMS and R/S