DBI: R Database Interface

Share:

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.

Author
R Special Interest Group on Databases (R-SIG-DB) [aut], Hadley Wickham [aut], Kirill Müller [aut, cre]
Date of publication
2016-09-10 01:27:20
Maintainer
Kirill Müller <krlmlr+r@mailbox.org>
License
LGPL (>= 2)
Version
0.5-1
URLs

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