{ "_id": "6a0f6692acfb0bcc41c5d4e3", "Package": "SQRL", "Type": "Package", "Title": "Enhances Interaction with 'ODBC' Databases", "Version": "1.0.3", "Date": "2026-04-21", "Authors@R": "person(given = \"Mike\", family = \"Lee\", role = c(\"aut\", \"cre\"),\nemail = \"random.deviate@gmail.com\")", "Author": "Mike Lee [aut, cre]", "Maintainer": "Mike Lee ", "Description": "Provides simple and powerful interfaces that facilitate\ninteraction with 'ODBC' data sources. Each data source gets its\nown unique and dedicated interface, wrapped around 'RODBC'.\nCommunication settings are remembered between queries, and are\nmanaged silently in the background. The interfaces support\nmulti-statement 'SQL' scripts, which can be parameterised via\nmetaprogramming structures and embedded 'R' expressions.", "License": "GPL-3", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-21 09:51:30 UTC", "User": "root" }, "Repository": "https://cran.r-universe.dev", "Date/Publication": "2026-04-21 14:12:35 UTC", "RemoteUrl": "https://github.com/cran/SQRL", "RemoteRef": "HEAD", "RemoteSha": "92c3b429c18a228e557c197b68ada3068dc173ae", "MD5sum": "c0571dd46d7f5b04753f1c97f067cb40", "_user": "cran", "_type": "src", "_file": "SQRL_1.0.3.tar.gz", "_fileid": "e1e98b97ed22a31929f0021294654dae4c3df426819e11d013d4b71f36485052", "_filesize": 455935, "_sha256": "e1e98b97ed22a31929f0021294654dae4c3df426819e11d013d4b71f36485052", "_created": "2026-05-21T09:51:30.000Z", "_published": "2026-05-21T20:09:54.645Z", "_distro": "noble", "_jobs": [ { "job": 77259197628, "time": 105, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7132649037" }, { "job": 77259197602, "time": 107, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7132649217" }, { "job": 77259196873, "time": 159, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7132611434" }, { "job": 77259196889, "time": 103, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7146080200" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/26218595286", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/SQRL", "_commit": { "id": "92c3b429c18a228e557c197b68ada3068dc173ae", "author": "Mike Lee ", "committer": "cran-robot ", "message": "version 1.0.3\n", "time": 1776780755 }, "_maintainer": { "name": "Mike Lee", "email": "random.deviate@gmail.com" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.3.0", "role": "Depends" }, { "package": "RODBC", "role": "Imports" }, { "package": "tools", "role": "Suggests" }, { "package": "utils", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 0, "_updates": [ { "week": "2026-17", "n": 1 } ], "_tags": [ { "name": "1.0.3", "date": "2026-04-21" } ], "_stars": 0, "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 620, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SQRL" }, "_searchresults": 9, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/SQRL.html", "manual.pdf" ], "_realowner": "cran", "_cranurl": false, "_releases": [ { "version": "0.1.0", "date": "2017-11-12" }, { "version": "0.1.1", "date": "2018-01-08" }, { "version": "0.2.0", "date": "2018-03-08" }, { "version": "0.2.1", "date": "2018-03-10" }, { "version": "0.3.0", "date": "2018-04-16" }, { "version": "0.4.0", "date": "2018-06-03" }, { "version": "0.5.0", "date": "2018-10-12" }, { "version": "0.6.0", "date": "2019-01-31" }, { "version": "0.6.1", "date": "2019-02-01" }, { "version": "0.6.2", "date": "2019-02-14" }, { "version": "0.6.3", "date": "2019-07-08" }, { "version": "0.7.0", "date": "2019-11-07" }, { "version": "0.7.1", "date": "2020-03-14" }, { "version": "0.7.2", "date": "2020-05-13" }, { "version": "0.7.3", "date": "2020-08-27" }, { "version": "0.7.4", "date": "2020-11-22" }, { "version": "0.8.0", "date": "2021-03-07" }, { "version": "1.0.0", "date": "2021-09-30" }, { "version": "1.0.1", "date": "2022-09-20" }, { "version": "1.0.2", "date": "2023-12-03" }, { "version": "1.0.3", "date": "2026-04-21" } ], "_exports": [ "sqrlAll", "sqrlInterface", "sqrlOff", "sqrlSource", "sqrlSources" ], "_help": [ { "page": "SQRL-package", "title": "Simple and Powerful ODBC Interfaces", "topics": [ "SQRL-package", "SQRL", "sqrl" ] }, { "page": "sqrlAll", "title": "Broadcast a Command to All Data Sources", "topics": [ "sqrlAll" ] }, { "page": "sqrlConfig", "title": "Configuration Files", "topics": [ "sqrlConfig" ] }, { "page": "sqrlInterface", "title": "Creates Data Source Interfaces", "topics": [ "sqrlInterface" ] }, { "page": "sqrlOff", "title": "Close Connections and Deactivate the Package", "topics": [ "sqrlOff" ] }, { "page": "sqrlParams", "title": "Control and Communication Parameters", "topics": [ "sqrlParams" ] }, { "page": "sqrlScript", "title": "Hybrid Script Syntax", "topics": [ "sqrlScript" ] }, { "page": "sqrlSource", "title": "Define New Data Sources", "topics": [ "sqrlSource" ] }, { "page": "sqrlSources", "title": "List Data Sources and their Interfaces", "topics": [ "sqrlSources" ] }, { "page": "sqrlUsage", "title": "How to Use the Interface Functions", "topics": [ "sqrlUsage" ] } ], "_rundeps": [ "RODBC" ], "_vignettes": [ { "source": "SQRL_primer.Rnw", "filename": "SQRL_primer.pdf", "title": "SQRL Features and Usage", "engine": "utils::Sweave", "headings": [], "created": "2021-09-30 03:30:02", "modified": "2026-04-21 14:12:35", "commits": 4 } ], "_score": 2, "_indexed": true, "_nocasepkg": "sqrl", "_universes": [ "cran" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.3", "date": "2026-05-21T09:53:22.000Z", "distro": "noble", "commit": "92c3b429c18a228e557c197b68ada3068dc173ae", "fileid": "d6c0cbd5ed1e5861385de5e84a4a07094131bf3d4518804067d856d1011ec440", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26218595286" }, { "r": "4.6.0", "os": "linux", "version": "1.0.3", "date": "2026-05-21T09:53:22.000Z", "distro": "noble", "commit": "92c3b429c18a228e557c197b68ada3068dc173ae", "fileid": "12b134aeab69c48f4512993eccda17986144080ac67cc6e37f54a41a4e51a85b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26218595286" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.3", "date": "2026-05-21T20:09:38.000Z", "commit": "92c3b429c18a228e557c197b68ada3068dc173ae", "fileid": "6a80dba05b66563b39509849324b0d8eaa1b8e11d00883baf4b5bbb30d75d177", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/26218595286" } ] }