{ "_id": "6a0f7107acfb0bcc41c5f65b", "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", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.2.3", "VignetteBuilder": "knitr", "Config/pak/sysreqs": "make default-jdk unixodbc-dev libx11-dev", "Repository": "https://samkerns.r-universe.dev", "Date/Publication": "2025-04-18 18:50:14 UTC", "RemoteUrl": "https://github.com/samkerns/sqlove", "RemoteRef": "HEAD", "RemoteSha": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-21 07:22:56 UTC", "User": "root" }, "Author": "Kerns Sam [aut, cre]", "Maintainer": "Kerns Sam ", "MD5sum": "2d22ade543ac8569e84368d6066f6d79", "_user": "samkerns", "_type": "src", "_file": "SQLove_1.0.2.tar.gz", "_fileid": "448d8bc47bdd698e50f7101cc48ae57bd77c75fee580d9f41df9df78ea3ab2ff", "_filesize": 88215, "_sha256": "448d8bc47bdd698e50f7101cc48ae57bd77c75fee580d9f41df9df78ea3ab2ff", "_created": "2026-05-21T07:22:56.000Z", "_published": "2026-05-21T20:54:31.099Z", "_distro": "noble", "_jobs": [ { "job": 77266688227, "time": 123, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7129650519" }, { "job": 77266688265, "time": 123, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7129650510" }, { "job": 77266688277, "time": 180, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7129649880" }, { "job": 77266688215, "time": 165, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7129652716" }, { "job": 77266687431, "time": 212, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7129609775" }, { "job": 77266687497, "time": 131, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7146980291" }, { "job": 77266688379, "time": 96, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7129641849" }, { "job": 77266688098, "time": 127, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7129652309" }, { "job": 77266687887, "time": 96, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7129643267" } ], "_buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/samkerns/sqlove", "_commit": { "id": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "author": "Samuel Kerns ", "committer": "Samuel Kerns ", "message": "Oops, spelling error in the README. Classic.\n", "time": 1745002214 }, "_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": "samkerns", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "samkerns", "count": 1, "uuid": 62064156 } ], "_userbio": { "uuid": 62064156, "type": "user", "name": "Sam Kerns", "description": "Lead Data Scientist | Researcher | Data Storyteller" }, "_downloads": { "count": 587, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SQLove" }, "_devurl": "https://github.com/samkerns/sqlove", "_searchresults": 2, "_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", "manual.pdf" ], "_homeurl": "https://github.com/samkerns/sqlove", "_realowner": "samkerns", "_cranurl": true, "_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/samkerns/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.10+7-1~24.04", "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-10 16:38:11", "modified": "2025-04-18 15:22:19", "commits": 3 } ], "_score": 3.6989700043360187, "_indexed": true, "_nocasepkg": "sqlove", "_universes": [ "samkerns" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.2", "date": "2026-05-21T07:25:08.000Z", "distro": "noble", "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "fileid": "3ca571dc01858f2d029fb96f02c913360299f5eb8b233c2b25a7e368c4e4770c", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557" }, { "r": "4.6.0", "os": "linux", "version": "1.0.2", "date": "2026-05-21T07:25:09.000Z", "distro": "noble", "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "fileid": "ad2fb8aaa09ea5a54bae590754f65bb3471235fa20f394a5b9511a708f0f1f8c", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557" }, { "r": "4.5.3", "os": "mac", "version": "1.0.2", "date": "2026-05-21T07:25:09.000Z", "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "fileid": "7712d3f6adb6a9bbc5ab09ffeeb44936d398d000dab8855edebe25d45e5e7a96", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557" }, { "r": "4.6.0", "os": "mac", "version": "1.0.2", "date": "2026-05-21T07:25:16.000Z", "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "fileid": "0372a3f88322d584633c82f269bd3acc71230234b4352da1d0bbf8783d503e0a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.2", "date": "2026-05-21T20:54:11.000Z", "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "fileid": "82a7b531b1fdfa7e8cd97834f104904f459eb8191b6637ad85cb0da498a6fc0e", "status": "success", "buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557" }, { "r": "4.7.0", "os": "win", "version": "1.0.2", "date": "2026-05-21T07:24:29.000Z", "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "fileid": "a62a787fb11856e1230066d83081da3205f9a06144a9124377b7cb9960d8ba48", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557" }, { "r": "4.5.3", "os": "win", "version": "1.0.2", "date": "2026-05-21T07:25:07.000Z", "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "fileid": "88963caf77b87ba69098e109641319942259f1099b49af341a2c4c2b43416d8d", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557" }, { "r": "4.6.0", "os": "win", "version": "1.0.2", "date": "2026-05-21T07:24:33.000Z", "commit": "9ad293c86b6bcd2a65be8c964a55234cdb774127", "fileid": "caa3665ff3835cc4b5367626dee62e3fd34f5a9a83ed22a6b0ab13b1ff3f46da", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/samkerns/actions/runs/26211555557" } ] }