{ "_id": "6a3125f73efcd9bda435df04", "Package": "SQLove", "Title": "Execute 'SQL' Scripts in 'R' Containing Multiple Queries", "Version": "1.0.2", "Authors@R": "person(\"Kerns\", \"Sam\", , \"samwkerns@gmail.com\", role = c(\"aut\", \"cre\"))", "Description": "The nature of working with structured query language\n('SQL') scripts efficiently often requires the creation of\ntemporary tables and there are few clean and simple 'R' 'SQL'\nexecution approaches that allow you to complete this kind of\nwork with the 'R' environment. This package seeks to give 'SQL'\nimplementations in 'R' a little love by deploying functions\nthat allow you to deploy complex 'SQL' scripts within a typical\n'R' workflow.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "RoxygenNote": "7.2.3", "VignetteBuilder": "knitr", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-16 10:28:11 UTC", "User": "root" }, "Author": "Kerns Sam [aut, cre]", "Maintainer": "Kerns Sam ", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2025-04-17 06:40:01 UTC", "RemoteUrl": "https://github.com/cran/SQLove", "RemoteRef": "HEAD", "RemoteSha": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "MD5sum": "b644b4a2978ffd77b659058c18c325db", "_user": "cran", "_type": "src", "_file": "SQLove_1.0.2.tar.gz", "_fileid": "e5dada11ea8b1b51ad841ab575aba4033eea4028fe8b34cc247d927be73e890b", "_filesize": 89094, "_sha256": "e5dada11ea8b1b51ad841ab575aba4033eea4028fe8b34cc247d927be73e890b", "_created": "2026-06-16T10:28:11.000Z", "_published": "2026-06-16T10:31:19.741Z", "_distro": "noble", "_jobs": [ { "job": 81635749595, "time": 111, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7664146617" }, { "job": 81635749534, "time": 134, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7664154563" }, { "job": 81635212734, "time": 183, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7664103464" }, { "job": 81635749575, "time": 142, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7664160562" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/27611014269", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/SQLove", "_commit": { "id": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "author": "Kerns Sam ", "committer": "cran-robot ", "message": "version 1.0.2\n", "time": 1744872001 }, "_maintainer": { "name": "Kerns Sam", "email": "samwkerns@gmail.com", "login": "samkerns", "description": "Lead Data Scientist | Researcher | Data Storyteller", "uuid": 62064156 }, "_registered": true, "_dependencies": [ { "package": "DBI", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "RJDBC", "role": "Imports" }, { "package": "odbc", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "samkerns", "count": 6, "uuid": 62064156 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 609, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 591, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SQLove" }, "_searchresults": 3, "_topics": [ "openjdk" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/SQLove.html", "LICENSE", "manual.pdf" ], "_homeurl": "https://github.com/samkerns/sqlove", "_realowner": "samkerns", "_cranurl": false, "_releases": [ { "version": "0.0.1", "date": "2023-02-16" }, { "version": "0.0.2", "date": "2023-03-06" }, { "version": "0.0.3", "date": "2023-11-10" }, { "version": "0.0.4", "date": "2023-11-13" }, { "version": "1.0.1", "date": "2025-04-10" }, { "version": "1.0.2", "date": "2025-04-17" } ], "_exports": [ "dbGetMultiQuery", "dbSendMultiUpdate" ], "_help": [ { "page": "dbGetMultiQuery", "title": "Query a database with multiple query actions and one, final, select statement.", "topics": [ "dbGetMultiQuery" ] }, { "page": "dbSendMultiUpdate", "title": "Run multiple SQL query actions within the DB environment.", "topics": [ "dbSendMultiUpdate" ] } ], "_readme": "https://github.com/cran/SQLove/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cli", "clipr", "cpp11", "crayon", "DBI", "glue", "hms", "lifecycle", "magrittr", "odbc", "pillar", "pkgconfig", "prettyunits", "progress", "R6", "Rcpp", "readr", "rJava", "RJDBC", "rlang", "tibble", "tidyselect", "tzdb", "utf8", "vctrs", "vroom", "withr" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-21-jre-headless", "headers": "openjdk-21-jre-headless", "source": "openjdk", "version": "21.0.11+10-1~24.04.2", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_vignettes": [ { "source": "SQLove.Rmd", "filename": "SQLove.html", "title": "SQLove - Simple Functions for Complex Queries", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "The Problem", "dbGetMultiQuery", "dbSendMultiUpdate" ], "created": "2023-02-16 14:30:11", "modified": "2025-04-17 06:40:01", "commits": 2 } ], "_score": 2.6989700043360187, "_indexed": false, "_nocasepkg": "sqlove", "_universes": [ "cran" ], "_indexurl": "https://samkerns.r-universe.dev/SQLove", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.2", "date": "2026-06-16T10:30:12.000Z", "distro": "noble", "commit": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "fileid": "08a8ce6eeadac8afdc3d2775b18c44c498c5a693944396c1102142424f690efc", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/cran/actions/runs/27611014269" }, { "r": "4.6.0", "os": "linux", "version": "1.0.2", "date": "2026-06-16T10:30:34.000Z", "distro": "noble", "commit": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "fileid": "db7c10bd61ba91a88dddec5164f743eddfffb1ed531ad8cb857cbb60c8441ae3", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/cran/actions/runs/27611014269" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.2", "date": "2026-06-16T10:30:31.000Z", "commit": "3b17ddf71ad3c8da449cc274fe5eee4f9b85ddea", "fileid": "244d8501006b0804d66d949dc106aa41bfaa57e73dcfa85e6b3faac840fab383", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/27611014269" } ] }