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
card.svg |card.png
ETLUtils/json (API)
NEWS

# 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.85 score 20 stars 35 scripts 266 downloads 11 exports 2 dependencies

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

TargetResultTimeFilesSyslog
linux-devel-x86_64OK106
source / vignettesOK152
linux-release-x86_64OK105
macos-release-arm64OK89
macos-oldrel-arm64OK76
windows-develOK83
windows-releaseOK211
windows-oldrelOK61
wasm-releaseOK91

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

Dependencies:bitff