Package: RODBCDBI 0.1.1

RODBCDBI: Provides Access to Databases Through the ODBC Interface

An implementation of R's DBI interface using ODBC package as a back-end. This allows R to connect to any DBMS that has a ODBC driver.

Authors:Nagi Teramo [aut, cre], Shinichi Takayanagi [aut]

RODBCDBI_0.1.1.tar.gz
RODBCDBI_0.1.1.zip(r-4.5)RODBCDBI_0.1.1.zip(r-4.4)RODBCDBI_0.1.1.zip(r-4.3)
RODBCDBI_0.1.1.tgz(r-4.4-any)RODBCDBI_0.1.1.tgz(r-4.3-any)
RODBCDBI_0.1.1.tar.gz(r-4.5-noble)RODBCDBI_0.1.1.tar.gz(r-4.4-noble)
RODBCDBI_0.1.1.tgz(r-4.4-emscripten)RODBCDBI_0.1.1.tgz(r-4.3-emscripten)
RODBCDBI.pdf |RODBCDBI.html
RODBCDBI/json (API)

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

Peer review:

Bug tracker:https://github.com/teramonagi/rodbcdbi/issues

On CRAN:

4.69 score 12 stars 41 scripts 254 downloads 19 exports 2 dependencies

Last updated 8 years agofrom:915ef7da07. Checks:OK: 3 NOTE: 4. Indexed: yes.

TargetResultDate
Doc / VignettesOKOct 27 2024
R-4.5-winNOTEOct 27 2024
R-4.5-linuxNOTEOct 27 2024
R-4.4-winNOTEOct 27 2024
R-4.4-macNOTEOct 27 2024
R-4.3-winOKOct 27 2024
R-4.3-macOKOct 27 2024

Exports:dbClearResultdbColumnInfodbConnectdbDisconnectdbExistsTabledbFetchdbGetInfodbGetRowCountdbGetStatementdbHasCompleteddbIsValiddbListFieldsdbListTablesdbReadTabledbRemoveTabledbSendQuerydbUnloadDriverdbWriteTableODBC

Dependencies:DBIRODBC

Readme and manuals

Help Manual

Help pageTopics
Connect/disconnect to a ODBC data sourcedbConnect,ODBCDriver-method
Close a current session.dbDisconnect,ODBCConnection-method
Does the table exist?dbExistsTable,ODBCConnection,character-method
Get DBMS metadata.dbGetInfo,ODBCConnection-method
List fields in specified table.dbListFields,ODBCConnection,character-method
List available ODBC tables.dbListTables,ODBCConnection-method
Convenience functions for importing/exporting DBMS tablesdbReadTable,ODBCConnection,character-method
Remove a table from the database.dbRemoveTable,ODBCConnection,character-method
Execute a statement on a given database connection.dbClearResult,ODBCResult-method dbFetch,ODBCResult-method dbHasCompleted,ODBCResult-method dbSendQuery,ODBCConnection-method
Write a local data frame or file to the database.dbWriteTable,ODBCConnection,character,data.frame-method
Generate an object of ODBCDriver classODBC
Database interface meta-data.dbColumnInfo,ODBCResult-method dbGetInfo,ODBCResult-method dbGetRowCount,ODBCResult-method dbGetStatement,ODBCResult-method odbc-meta
RODBCDBIRODBCDBI-package RODBCDBI