Package: ETLUtils 1.6

ETLUtils: Utility Functions to Execute Standard Extract/Transform/Load Operations (using Package 'ff') on Large Data

Provides functions to facilitate the use of the 'ff' package in interaction with big data in 'SQL' databases (e.g. in 'Oracle', 'MySQL', 'PostgreSQL', 'Hive') by allowing easy importing directly into 'ffdf' objects using 'DBI', 'RODBC' and 'RJDBC'. Also contains some basic utility functions to do fast left outer join merging based on 'match', factorisation of data and a basic function for re-coding vectors.

Authors:Jan Wijffels [aut, cre]

ETLUtils_1.6.tar.gz
ETLUtils_1.6.zip(r-4.7)ETLUtils_1.6.zip(r-4.6)ETLUtils_1.6.zip(r-4.5)
ETLUtils_1.6.tgz(r-4.6-any)ETLUtils_1.6.tgz(r-4.5-any)
ETLUtils_1.6.tar.gz(r-4.7-any)ETLUtils_1.6.tar.gz(r-4.6-any)
ETLUtils_1.6.tgz(r-4.6-emscripten)
manual.pdf |manual.html
DESCRIPTION |NEWS
card.svg |card.png
ETLUtils/json (API)

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

Bug tracker:https://github.com/jwijffels/etlutils/issues

On CRAN:

Conda:

4.86 score 19 stars 38 scripts 364 downloads 11 exports 2 dependencies

Last updated from:1aee5ebeae. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK104
source / vignettesOK138
linux-release-x86_64OK104
macos-release-arm64OK73
macos-oldrel-arm64OK65
windows-develOK74
windows-releaseOK89
windows-oldrelOK78
wasm-releaseOK93

Exports:factorisematchmergenaLOCFPlusoneread.dbi.ffdfread.jdbc.ffdfread.odbc.ffdfrecoderrenameColumnswrite.dbi.ffdfwrite.jdbc.ffdfwrite.odbc.ffdf

Dependencies:bitff