Package: DBI 1.2.3.9012

Kirill Müller

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.

Authors:R Special Interest Group on Databases [aut], Hadley Wickham [aut], Kirill Müller [aut, cre], R Consortium [fnd]

DBI_1.2.3.9012.tar.gz
DBI_1.2.3.9012.zip(r-4.5)DBI_1.2.3.9012.zip(r-4.4)DBI_1.2.3.9012.zip(r-4.3)
DBI_1.2.3.9012.tgz(r-4.4-any)DBI_1.2.3.9012.tgz(r-4.3-any)
DBI_1.2.3.9012.tar.gz(r-4.5-noble)DBI_1.2.3.9012.tar.gz(r-4.4-noble)
DBI_1.2.3.9012.tgz(r-4.4-emscripten)DBI_1.2.3.9012.tgz(r-4.3-emscripten)
DBI.pdf |DBI.html✨
DBI/json (API)
NEWS

# Install 'DBI' in R:
install.packages('DBI', repos = c('https://r-dbi.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/r-dbi/dbi/issues

On CRAN:

databaseinterface

77 exports 296 stars 15.58 score 0 dependencies 2658 dependents 12 mentions 17.2k scripts 636.3k downloads

Last updated 8 days agofrom:dc77e36d55. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKAug 31 2024
R-4.5-winOKAug 31 2024
R-4.5-linuxOKAug 31 2024
R-4.4-winOKAug 31 2024
R-4.4-macOKAug 31 2024
R-4.3-winOKAug 31 2024
R-4.3-macOKAug 31 2024

Exports:.SQL92KeywordsANSIdbAppendTabledbAppendTableArrowdbBegindbBinddbBindArrowdbBreakdbCallProcdbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbCreateTableArrowdbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbFetchArrowdbFetchArrowChunkdbGetConnectArgsdbGetDBIVersiondbGetExceptiondbGetInfodbGetQuerydbGetQueryArrowdbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListConnectionsdbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbReadTableArrowdbRemoveTabledbRollbackdbSendQuerydbSendQueryArrowdbSendStatementdbSetDataMappingsdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTabledbWriteTableArrowfetchIdisSQLKeywordisSQLKeyword.defaultmake.db.namesmake.db.names.defaultshowSQLsqlAppendTablesqlAppendTableTemplatesqlColumnToRownamessqlCommentSpecsqlCreateTablesqlDatasqlInterpolateSQLKeywordssqlParseVariablessqlParseVariablesImplsqlQuoteSpecsqlRownamesToColumn

Dependencies:

A Common Database Interface (DBI)

R-Databases Special Interest Group

Rendered fromDBI-1.Rmdusingknitr::rmarkdownon Aug 31 2024.

Last update: 2023-12-20
Started: 2015-02-25

A Common Interface to Relational Databases from R and S -- A Proposal

David James

Rendered fromDBI-proposal.Rmdusingknitr::rmarkdownon Aug 31 2024.

Last update: 2023-12-20
Started: 2015-02-25

Advanced DBI Usage

James Wondrasek, Kirill Müller

Rendered fromDBI-advanced.Rmdusingknitr::rmarkdownon Aug 31 2024.

Last update: 2024-06-02
Started: 2021-01-02

DBI specification

Kirill Müller

Rendered fromspec.Rmdusingknitr::rmarkdownon Aug 31 2024.

Last update: 2024-02-09
Started: 2017-02-28

History of DBI

David James

Rendered fromDBI-history.Rmdusingknitr::rmarkdownon Aug 31 2024.

Last update: 2023-11-08
Started: 2019-11-22

Implementing a new backend

Hadley Wickham, Kirill Müller

Rendered frombackend.Rmdusingknitr::rmarkdownon Aug 31 2024.

Last update: 2021-01-16
Started: 2015-01-27

Introduction to DBI

James Wondrasek, Katharina Brunner, Kirill Müller

Rendered fromDBI.Rmdusingknitr::rmarkdownon Aug 31 2024.

Last update: 2024-06-02
Started: 2019-11-22

Using DBI with Arrow

Kirill Müller

Rendered fromDBI-arrow.Rmdusingknitr::rmarkdownon Aug 31 2024.

Last update: 2023-12-27
Started: 2022-09-29

Readme and manuals

Help Manual

Help pageTopics
DBI: R Database InterfaceDBI-package DBI
Keywords according to the SQL-92 standard.SQL92Keywords
Insert rows into a tabledbAppendTable
Insert rows into a table from an Arrow streamdbAppendTableArrow
Begin/commit/rollback SQL transactionsdbBegin dbCommit dbRollback transactions
Bind values to a parameterized/prepared statementdbBind dbBindArrow
Check if a connection to a DBMS can be establisheddbCanConnect
Clear a result setdbClearResult
Information about result typesdbColumnInfo
Create a connection to a DBMSdbConnect
Create a table in the databasedbCreateTable
Create a table in the database based on an Arrow objectdbCreateTableArrow
Determine the SQL data type of an objectdbDataType
Disconnect (close) a connectiondbDisconnect
Change database statedbExecute
Does a table exist?dbExistsTable
Fetch records from a previously executed querydbFetch fetch
Fetch records from a previously executed query as an Arrow objectdbFetchArrow
Fetch the next batch of records from a previously executed query as an Arrow objectdbFetchArrowChunk
Get connection argumentsdbGetConnectArgs
Get DBMS metadatadbGetInfo
Retrieve results from a querydbGetQuery
Retrieve results from a query as an Arrow objectdbGetQueryArrow
The number of rows fetched so fardbGetRowCount
The number of rows affecteddbGetRowsAffected
Get the statement associated with a result setdbGetStatement
Completion statusdbHasCompleted
DBIConnection classDBIConnection-class
DBIConnector classDBIConnector-class
DBIDriver classDBIDriver-class
DBIObject classDBIObject-class
DBIResult classDBIResult-class
DBIResultArrow classDBIResultArrow-class DBIResultArrowDefault-class
Is this DBMS object read only?dbIsReadOnly
Is this DBMS object still valid?dbIsValid
List field names of a remote tabledbListFields
List remote objectsdbListObjects
List remote tablesdbListTables
Quote identifiersdbQuoteIdentifier
Quote literal valuesdbQuoteLiteral
Quote literal stringsdbQuoteString
Read database tables as data framesdbReadTable
Read database tables as Arrow objectsdbReadTableArrow
Remove a table from the databasedbRemoveTable
Execute a query on a given database connectiondbSendQuery
Execute a query on a given database connection for retrieval via ArrowdbSendQueryArrow
Execute a data manipulation statement on a given database connectiondbSendStatement
Unquote identifiersdbUnquoteIdentifier
Self-contained SQL transactionsdbBreak dbWithTransaction
Copy data frames to database tablesdbWriteTable
Copy Arrow objects to database tablesdbWriteTableArrow
Refer to a table nested in a hierarchy (e.g. within a schema)Id Id-class
Convert row names back and forth between columnsrownames sqlColumnToRownames sqlRownamesToColumn
SQL quotingSQL SQL-class
Compose query to insert rows into a tablesqlAppendTable sqlAppendTableTemplate
Compose query to create a simple tablesqlCreateTable
Convert a data frame into form suitable for upload to an SQL databasesqlData
Safely interpolate values into an SQL stringsqlInterpolate