{ "_id": "6a13ffefacfb0bcc41d37c80", "Package": "ETLUtils", "Title": "Utility Functions to Execute Standard Extract/Transform/Load\nOperations (using Package 'ff') on Large Data", "Type": "Package", "LazyLoad": "yes", "Authors@R": "person(given = \"Jan\", family = \"Wijffels\", role = c(\"aut\", \"cre\"), email = \"jwijffels@bnosac.be\")", "Description": "Provides functions to facilitate the use of the 'ff'\npackage in interaction with big data in 'SQL' databases (e.g.\nin 'Oracle', 'MySQL', 'PostgreSQL', 'Hive') by allowing easy\nimporting directly into 'ffdf' objects using 'DBI', 'RODBC' and\n'RJDBC'. Also contains some basic utility functions to do fast\nleft outer join merging based on 'match', factorisation of data\nand a basic function for re-coding vectors.", "Version": "1.6", "License": "GPL-2", "URL": "https://github.com/jwijffels/ETLUtils", "RoxygenNote": "7.3.2", "Repository": "https://jwijffels.r-universe.dev", "Date/Publication": "2025-11-26 22:33:38 UTC", "RemoteUrl": "https://github.com/jwijffels/etlutils", "RemoteRef": "HEAD", "RemoteSha": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-25 07:49:06 UTC", "User": "root" }, "Author": "Jan Wijffels [aut, cre]", "Maintainer": "Jan Wijffels ", "MD5sum": "00111dbb8337f29d8e42a78d972a382f", "_user": "jwijffels", "_type": "src", "_file": "ETLUtils_1.6.tar.gz", "_fileid": "ab2aa5ef2190087516159bffaa9cd063b92bcb92b6cdf0ae67823778cffff18f", "_filesize": 183505, "_sha256": "ab2aa5ef2190087516159bffaa9cd063b92bcb92b6cdf0ae67823778cffff18f", "_created": "2026-05-25T07:49:06.000Z", "_published": "2026-05-25T07:53:19.826Z", "_distro": "noble", "_jobs": [ { "job": 77676162020, "time": 106, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7194020777" }, { "job": 77676162037, "time": 105, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7194020590" }, { "job": 77676162007, "time": 76, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7194012476" }, { "job": 77676162003, "time": 89, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7194015928" }, { "job": 77675847997, "time": 152, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7193991976" }, { "job": 77676161970, "time": 91, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7194016825" }, { "job": 77676162038, "time": 83, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7194014168" }, { "job": 77676162032, "time": 61, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7194008366" }, { "job": 77676162029, "time": 211, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7194047797" } ], "_buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/jwijffels/etlutils", "_commit": { "id": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "author": "Jan Wijffels ", "committer": "Jan Wijffels ", "message": "fix R CMD check note on authors@R\n", "time": 1764196418 }, "_maintainer": { "name": "Jan Wijffels", "email": "jwijffels@bnosac.be", "login": "jwijffels", "description": "www.bnosac.be", "uuid": 1710810 }, "_registered": true, "_dependencies": [ { "package": "ff", "version": ">= 4.0.0", "role": "Depends" }, { "package": "bit", "version": ">= 4.0.0", "role": "Imports" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "zoo", "role": "Suggests" }, { "package": "DBI", "role": "Suggests" }, { "package": "RODBC", "role": "Suggests" }, { "package": "RJDBC", "role": "Suggests" } ], "_owner": "jwijffels", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-48", "n": 1 } ], "_tags": [], "_stars": 20, "_contributors": [ { "user": "jwijffels", "count": 53, "uuid": 1710810 }, { "user": "epatters", "count": 2, "uuid": 316610 }, { "user": "mpancia", "count": 1, "uuid": 7557730 } ], "_userbio": { "uuid": 1710810, "type": "user", "name": "jwijffels", "description": "www.bnosac.be" }, "_downloads": { "count": 266, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ETLUtils" }, "_devurl": "https://github.com/jwijffels/etlutils", "_searchresults": 35, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/ETLUtils.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/jwijffels/etlutils", "_realowner": "jwijffels", "_cranurl": true, "_releases": [ { "version": "1.0", "date": "2012-04-03" }, { "version": "1.1", "date": "2012-05-20" }, { "version": "1.2", "date": "2013-01-05" }, { "version": "1.3", "date": "2015-05-18" }, { "version": "1.4", "date": "2018-01-17" }, { "version": "1.4.1", "date": "2018-01-25" }, { "version": "1.5", "date": "2020-08-03" }, { "version": "1.6", "date": "2025-11-26" } ], "_exports": [ "factorise", "matchmerge", "naLOCFPlusone", "read.dbi.ffdf", "read.jdbc.ffdf", "read.odbc.ffdf", "recoder", "renameColumns", "write.dbi.ffdf", "write.jdbc.ffdf", "write.odbc.ffdf" ], "_help": [ { "page": "ETLUtils-package", "title": "Extra utility functions to execute standard ETL operations on large data", "topics": [ "ETLUtils-package", "ETLUtils" ] }, { "page": "factorise", "title": "Put character vectors, columns of a data.frame or list elements as factor", "topics": [ "factorise", "factorise.character", "factorise.data.frame", "factorise.default", "factorise.list" ] }, { "page": "matchmerge", "title": "Merge two data frames (fast) by common columns by performing a left (outer) join or an inner join.", "topics": [ "matchmerge" ] }, { "page": "naLOCFPlusone", "title": "Performs NA replacement by last observation carried forward but adds 1 to the last observation carried forward.", "topics": [ "naLOCFPlusone" ] }, { "page": "read.dbi.ffdf", "title": "Read data from a DBI connection into an ffdf.", "topics": [ "read.dbi.ffdf" ] }, { "page": "read.jdbc.ffdf", "title": "Read data from a JDBC connection into an ffdf.", "topics": [ "read.jdbc.ffdf" ] }, { "page": "read.odbc.ffdf", "title": "Read data from a ODBC connection into an ffdf.", "topics": [ "read.odbc.ffdf" ] }, { "page": "recoder", "title": "Recodes the values of a character vector", "topics": [ "recoder" ] }, { "page": "renameColumns", "title": "Renames variables in a data frame.", "topics": [ "renameColumns" ] }, { "page": "write.dbi.ffdf", "title": "Write ffdf data to a database table by using a DBI connection.", "topics": [ "write.dbi.ffdf" ] }, { "page": "write.jdbc.ffdf", "title": "Write ffdf data to a database table by using a JDBC connection.", "topics": [ "write.jdbc.ffdf" ] }, { "page": "write.odbc.ffdf", "title": "Write ffdf data to a database table by using a ODBC connection.", "topics": [ "write.odbc.ffdf" ] } ], "_readme": "https://github.com/jwijffels/etlutils/raw/HEAD/README.md", "_rundeps": [ "bit", "ff" ], "_score": 4.845098040014257, "_indexed": true, "_nocasepkg": "etlutils", "_universes": [ "jwijffels" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.6", "date": "2026-05-25T07:50:56.000Z", "distro": "noble", "commit": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "fileid": "70fd2fc8b8e0eed065240c7df0d741cb31c23d37cb17237ae9abcdc8ae7ec54e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806" }, { "r": "4.6.0", "os": "linux", "version": "1.6", "date": "2026-05-25T07:50:59.000Z", "distro": "noble", "commit": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "fileid": "1476db3682cd56451f829e35414b65528e31186ee2d03b3186e6231313ac2d56", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806" }, { "r": "4.5.3", "os": "mac", "version": "1.6", "date": "2026-05-25T07:50:31.000Z", "commit": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "fileid": "a0461aebe7d6c7aa3ba82f60f6a1da76b3dc7df278c8a768f68cd712cc520b6f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806" }, { "r": "4.6.0", "os": "mac", "version": "1.6", "date": "2026-05-25T07:50:41.000Z", "commit": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "fileid": "696b4c5011e2ac309da4de59afa9134b24b87132df7543e1ff6fd36a7a7107cc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806" }, { "r": "4.6.0", "os": "wasm", "version": "1.6", "date": "2026-05-25T07:50:54.000Z", "commit": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "fileid": "49ba0fd1eb6aaeee8cfbd8f12c1a85492487612417a3386a845d4164fb270099", "status": "success", "buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806" }, { "r": "4.7.0", "os": "win", "version": "1.6", "date": "2026-05-25T07:50:28.000Z", "commit": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "fileid": "53de28e225efae94d77e96912bff53351f4182a13399e9bc4300175e65385d22", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806" }, { "r": "4.5.3", "os": "win", "version": "1.6", "date": "2026-05-25T07:50:07.000Z", "commit": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "fileid": "e18b001e509c97157e2804e583d9d7887aea054f5338930f4a0c82ec2301d92f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806" }, { "r": "4.6.0", "os": "win", "version": "1.6", "date": "2026-05-25T07:52:36.000Z", "commit": "1aee5ebeaee94d0d6a64af6b003cc57353bb1803", "fileid": "3185f86841eeea0d3857e31304aa080814e810181293cf5ae46450b002631b86", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/jwijffels/actions/runs/26389575806" } ] }