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-any)ETLUtils_1.6.zip(r-4.6-any)ETLUtils_1.6.zip(r-4.5-any)
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.81 score 19 stars 34 scripts 351 downloads 11 exports 2 dependencies

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

TargetResultTimeFilesSyslog
linux-develOK111
source / vignettesOK150
linux-releaseOK114
macos-releaseOK98
macos-oldrelOK125
windows-develOK65
windows-releaseOK57
windows-oldrelOK64
wasm-releaseOK98

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

Dependencies:bitff