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.7)RODBCDBI_0.1.1.zip(r-4.6)RODBCDBI_0.1.1.zip(r-4.5)
RODBCDBI_0.1.1.tgz(r-4.6-any)RODBCDBI_0.1.1.tgz(r-4.5-any)
RODBCDBI_0.1.1.tar.gz(r-4.7-any)RODBCDBI_0.1.1.tar.gz(r-4.6-any)
RODBCDBI_0.1.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
RODBCDBI/json (API)

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

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

On CRAN:

Conda:

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

Last updated from:915ef7da07. Checks:7 NOTE, 2 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64NOTE117
source / vignettesOK212
linux-release-x86_64NOTE110
macos-release-arm64NOTE172
macos-oldrel-arm64NOTE179
windows-develNOTE76
windows-releaseNOTE70
windows-oldrelNOTE66
wasm-releaseOK98

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