DBI: R Database Interface

A database interface 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.

AuthorR Special Interest Group on Databases (R-SIG-DB) [aut], Hadley Wickham [aut], Kirill Müller [aut, cre]
Date of publication2016-09-10 01:27:20
MaintainerKirill Müller <krlmlr+r@mailbox.org>
LicenseLGPL (>= 2)
Version0.5-1
http://rstats-db.github.io/DBI

View on CRAN

Man pages

ANSI: A dummy DBI connector that simulates ANSI-SQL compliance

dbBind: Bind values to a parameterised/prepared statement

dbCallProc: Call an SQL stored procedure

dbClearResult: Clear a result set

dbColumnInfo: Information about result types

dbConnect: Create a connection to a DBMS

dbDataType: Determine the SQL data type of an object

dbDisconnect: Disconnect (close) a connection

dbDriver: Load and unload database drivers

dbExecute: Execute an update statement, query number of rows affected,...

dbExistsTable: Does a table exist?

dbFetch: Fetch records from a previously executed query

dbGetDBIVersion: Determine the current version of the package.

dbGetException: Get DBMS exceptions

dbGetInfo: Get DBMS metadata

dbGetQuery: Send query, retrieve results and then clear result set

dbGetRowCount: The number of rows fetched so far

dbGetRowsAffected: The number of rows affected

dbGetStatement: Get the statement associated with a result set

dbHasCompleted: Completion status

DBIConnection-class: DBIConnection class

DBIDriver-class: DBIDriver class

DBIObject-class: DBIObject class

DBI-package: R Database Interface

DBIResult-class: DBIResult class

DBIspec: DBI specification

dbIsValid: Is this DBMS object still valid?

dbListConnections: List currently open connections

dbListFields: List field names of a remote table

dbListResults: A list of all pending results

dbListTables: List remote tables

dbReadTable: Copy data frames to and from database tables

dbRemoveTable: Remove a table from the database

dbSendQuery: Execute a query on a given database connection

dbSendStatement: Execute a data manipulation statement on a given database...

dbSetDataMappings: Set data mappings between an DBMS and R.

dbWithTransaction: Self-contained SQL transactions

hidden_aliases: Internal page for hidden aliases

make.db.names: Make R identifiers into legal SQL identifiers

print.list.pairs: Print a list of pairs.

rownames: Convert row names back and forth between columns

SQL: SQL quoting

sqlAppendTable: Insert rows into a table

sqlCreateTable: Create a simple table

sqlData: Convert a data frame into form suitable for upload to a SQL...

sqlInterpolate: Safely interpolate values into an SQL string

sqlParseVariables: Parse interpolated variables from SQL.

Table: Refer to a table nested in a hierarchy (e.g. within a schema)

transactions: Begin/commit/rollback SQL transactions

Files in this package

DBI
DBI/inst
DBI/inst/doc
DBI/inst/doc/backend.Rmd
DBI/inst/doc/backend.html
DBI/inst/doc/DBI-proposal.html
DBI/inst/doc/DBI-1.Rmd
DBI/inst/doc/backend.R
DBI/inst/doc/DBI-1.html
DBI/inst/doc/DBI-proposal.Rmd
DBI/tests
DBI/tests/testthat.R
DBI/tests/testthat
DBI/tests/testthat/test-sql-df.R
DBI/tests/testthat/test-data-type.R
DBI/tests/testthat/helper-dummy.R
DBI/tests/testthat/test-rownames.R
DBI/tests/testthat/test-quoting.R
DBI/tests/testthat/test-interpolate.R
DBI/NAMESPACE
DBI/NEWS.md
DBI/R
DBI/R/DBResult.R DBI/R/interpolate.R DBI/R/data-types.R DBI/R/quote.R DBI/R/DBDriver.R DBI/R/data.R DBI/R/rownames.R DBI/R/DBObject.R DBI/R/deprecated.R DBI/R/hidden.R DBI/R/util.R DBI/R/transactions.R DBI/R/table.R DBI/R/table-insert.R DBI/R/DBConnection.R DBI/R/table-create.R DBI/R/DBI-package.R DBI/R/ANSI.R
DBI/vignettes
DBI/vignettes/backend.Rmd
DBI/vignettes/hierarchy.png
DBI/vignettes/DBI-1.Rmd
DBI/vignettes/DBI-proposal.Rmd
DBI/vignettes/biblio.bib
DBI/README.md
DBI/MD5
DBI/build
DBI/build/vignette.rds
DBI/DESCRIPTION
DBI/man
DBI/man/dbListResults.Rd DBI/man/dbGetInfo.Rd DBI/man/dbSendQuery.Rd DBI/man/dbListConnections.Rd DBI/man/dbIsValid.Rd DBI/man/ANSI.Rd DBI/man/DBIDriver-class.Rd DBI/man/hidden_aliases.Rd DBI/man/dbFetch.Rd DBI/man/sqlParseVariables.Rd DBI/man/dbColumnInfo.Rd DBI/man/sqlInterpolate.Rd DBI/man/dbListFields.Rd DBI/man/DBIConnection-class.Rd DBI/man/print.list.pairs.Rd DBI/man/dbHasCompleted.Rd DBI/man/dbSendStatement.Rd DBI/man/dbDriver.Rd DBI/man/dbExecute.Rd DBI/man/DBIResult-class.Rd DBI/man/dbGetRowsAffected.Rd DBI/man/sqlCreateTable.Rd DBI/man/Table.Rd DBI/man/dbRemoveTable.Rd DBI/man/dbGetException.Rd DBI/man/DBIObject-class.Rd DBI/man/make.db.names.Rd DBI/man/dbConnect.Rd DBI/man/dbExistsTable.Rd DBI/man/dbListTables.Rd DBI/man/dbGetQuery.Rd DBI/man/dbGetStatement.Rd DBI/man/dbDisconnect.Rd DBI/man/SQL.Rd DBI/man/rownames.Rd DBI/man/dbGetDBIVersion.Rd DBI/man/sqlData.Rd DBI/man/transactions.Rd DBI/man/dbDataType.Rd DBI/man/DBIspec.Rd DBI/man/DBI-package.Rd DBI/man/dbClearResult.Rd DBI/man/dbWithTransaction.Rd DBI/man/sqlAppendTable.Rd DBI/man/dbGetRowCount.Rd DBI/man/dbReadTable.Rd DBI/man/dbCallProc.Rd DBI/man/dbSetDataMappings.Rd DBI/man/dbBind.Rd
DBI/.Rinstignore

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

All documentation is copyright its authors; we didn't write any of that.