R Observatory: Metrics for ETLUtils version 1.6

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

ETLUtils

1.6

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

0packages depend

3.6Kdownloads / year

–test coverage

13/13checks pass

Overview

About

Maintained by Jan WijffelsFirst published 2012-04-038 releasesCRAN page ↗GitHub ↗

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.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("ETLUtils", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("jwijffels/ETLUtils")

Development version from jwijffels/ETLUtils. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-etlutils

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-ETLUtils

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-ETLUtils

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

13OK

Slowest check: 1.1 min · r-oldrel-macos-x86_64

Code health

None

Tests · ratio 0.00

not tracked

Coverage

100%

Documentation · exports

2

Dependencies · direct

Check history

OK2026-08-05
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
NOTE2026-08-01
12 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-03-10
14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Documentation

READMEYes · 182 wordsVignettesNopkgdown siteNoNEWSYes · 33% structuredCode of conductNoContributing guideNo

Examples that run: 83%
Documented parameters: 83%
Return-value docs: 100%
References docs: 0%

Downloads

3.6K

CRAN downloads in the past year

Rank #12,336 · ~10/day · ~301/mo

Releases R versions

Daily download trend is not available in this view yet.

23830 days

80590 days

3.6K1 year

Compare downloads with other packages →

Also on119 r2u14 autocran

Repository

GitHub ↗ jwijffels/etlutils

19Stars

6Forks

2Open issues

0Open PRs

0Releases

56Commits

3Contributors

56 commits · Last activity 2025-11-26

Stars over time

2021-11-30 · 192026-07-07 · 19

Repository practices

Upstream repositoryBeta

1 development-tooling and community-health practice detected across 1 family in the upstream repository

Checks run against github.com/jwijffels/etlutils on 2026-08-16.

Lint, format, editor (1)

RStudio project

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

7 external dependencies (excludes base and recommended)

Depends (1)

ff

Imports (1)

bit

LinkingTo (0)

none

Suggests (5)

RSQLite zoo DBI RODBC RJDBC

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (1)

Maintainer (1)

Jan Wijffels

Author, Maintainer

Authors (1)

Jan Wijffels

Author, Maintainer

Package Timeline

8 releases. Pick two to compare their code metrics. R releases are shown for context.

R
R 4.6.0 released · 2026-04-24
1.6Latest
2025-11-26 · current release · diff ↗
R
R 4.5.0 released · 2025-04-11
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21
R
R 4.2.0 released · 2022-04-22
R
R 4.1.0 released · 2021-05-18
1.5
2020-08-03 · diff ↗
R
R 4.0.0 released · 2020-04-24
R
R 3.6.0 released · 2019-04-26
R
R 3.5.0 released · 2018-04-23
1.4.1
2018-01-25 · diff ↗
1.4
2018-01-17 · diff ↗
R
R 3.4.0 released · 2017-04-21
R
R 3.3.0 released · 2016-05-03
1.3
2015-05-18 · diff ↗

Show 7 earlier events

R
R 3.2.0 released · 2015-04-16
R
R 3.1.0 released · 2014-04-10
R
R 3.0.0 released · 2013-04-03
1.2
2013-01-05 · diff ↗
1.1
2012-05-20 · diff ↗
1.0
2012-04-03
R
R 2.15.0 released · 2012-03-30

Package metadata

First published: 2012-04-03
Total releases: 8 / 14 yrs
License: GPL-2 OSI
Download size: 47 KB
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("ETLUtils")

Format

Wijffels, J. (2025). ETLUtils: Utility Functions to Execute Standard Extract/Transform/Load Operations (using Package 'ff') on Large Data (Version 1.6) [Computer software]. https://doi.org/10.32614/CRAN.package.ETLUtils

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for ETLUtils version 1.6 [Data set]. HJJB, LLC. Data release v2026-08-21. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-21, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →