{ "_id": "6a12a85eacfb0bcc41d1545e", "Package": "sqlhelper", "Title": "Easier 'SQL' Integration", "Version": "0.2.2", "Authors@R": "person(\"Matthew\", \"Roberts\", email = \"matthew@zsmr.uk\", role = c(\"aut\", \"cre\", \"cph\"))", "Description": "Execute files of 'SQL' and manage database connections.\n'SQL' statements and queries may be interpolated with string\nliterals. Execution of individual statements and queries may be\ncontrolled with keywords. Multiple connections may be defined\nwith 'YAML' and accessed by name.", "License": "GPL (>= 3)", "Encoding": "UTF-8", "RoxygenNote": "7.3.3", "Roxygen": "list(markdown = TRUE)", "Config/testthat/edition": "3", "VignetteBuilder": "knitr", "URL": "https://majerr.github.io/sqlhelper/dev/,\nhttps://github.com/majerr/sqlhelper/", "BugReports": "https://github.com/majerr/sqlhelper/issues", "Config/pak/sysreqs": "libabsl-dev cmake libgdal-dev gdal-bin libgeos-dev\nlibicu-dev libssl-dev libproj-dev libsqlite3-dev\nlibudunits2-dev", "Repository": "https://majerr.r-universe.dev", "Date/Publication": "2026-03-25 20:30:23 UTC", "RemoteUrl": "https://github.com/majerr/sqlhelper", "RemoteRef": "HEAD", "RemoteSha": "e79191a22ed638adc61f1b32d9fef9961195026c", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-24 07:17:49 UTC", "User": "root" }, "Author": "Matthew Roberts [aut, cre, cph]", "Maintainer": "Matthew Roberts ", "MD5sum": "b999b9e2ac173652bc38d458015b7485", "_user": "majerr", "_type": "src", "_file": "sqlhelper_0.2.2.tar.gz", "_fileid": "cc395688a6ea7a4b780e6c30d07ec1bedc64dae934c29c8cba4c2573b652e360", "_filesize": 192152, "_sha256": "cc395688a6ea7a4b780e6c30d07ec1bedc64dae934c29c8cba4c2573b652e360", "_created": "2026-05-24T07:17:49.000Z", "_published": "2026-05-24T07:27:26.296Z", "_distro": "noble", "_jobs": [ { "job": 77579901573, "time": 154, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7183210812" }, { "job": 77579901571, "time": 144, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7183209951" }, { "job": 77579901582, "time": 176, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7183251461" }, { "job": 77579901566, "time": 139, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7183246371" }, { "job": 77579720734, "time": 191, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7183191727" }, { "job": 77579901574, "time": 135, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7183208786" }, { "job": 77579901588, "time": 99, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7183204344" }, { "job": 77579901568, "time": 88, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7183203081" }, { "job": 77579901575, "time": 224, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7183219263" } ], "_buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/majerr/sqlhelper", "_commit": { "id": "e79191a22ed638adc61f1b32d9fef9961195026c", "author": "Matthew Roberts ", "committer": "GitHub ", "message": "Merge pull request #32 from majerr/fix/no-suggests-guards\n\nGuard examples and tests against missing Suggested packages", "time": 1774470623 }, "_maintainer": { "name": "Matthew Roberts", "email": "matthew@zsmr.uk", "login": "majerr", "description": "", "uuid": 13980531 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "yaml", "role": "Imports" }, { "package": "rappdirs", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "glue", "role": "Imports" }, { "package": "pool", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "purrr", "version": ">= 1.0.0", "role": "Imports" }, { "package": "sf", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "dplyr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "odbc", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "RPostgres", "role": "Suggests" }, { "package": "RMariaDB", "role": "Suggests" }, { "package": "bigrquery", "role": "Suggests" }, { "package": "spData", "role": "Suggests" } ], "_owner": "majerr", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-13", "n": 3 } ], "_tags": [], "_stars": 3, "_contributors": [ { "user": "majerr", "count": 159, "uuid": 13980531 } ], "_userbio": { "uuid": 13980531, "type": "user", "name": "Matthew Roberts" }, "_downloads": { "count": 524, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlhelper" }, "_devurl": "https://github.com/majerr/sqlhelper", "_pkgdown": "https://majerr.github.io/sqlhelper/dev/", "_searchresults": 39, "_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/sqlhelper.html", "manual.pdf" ], "_homeurl": "https://github.com/majerr/sqlhelper", "_realowner": "majerr", "_cranurl": true, "_releases": [ { "version": "0.2.1", "date": "2024-01-21" }, { "version": "0.2.2", "date": "2026-03-26" } ], "_exports": [ "config_examples", "connect", "connection_info", "default_conn", "disconnect", "get_default_conn_name", "is_connected", "live_connection", "not_connected", "prepare_sql", "read_sql", "run_files", "run_queries", "runfiles", "runqueries", "set_default_conn_name" ], "_help": [ { "page": "config_examples", "title": "Examples of yaml configurations for database connections", "topics": [ "config_examples" ] }, { "page": "connect", "title": "(Re-)Establish connections to databases", "topics": [ "connect" ] }, { "page": "connection_info", "title": "Browse available connections", "topics": [ "connection_info" ] }, { "page": "default_conn", "title": "Return the default connection", "topics": [ "default_conn" ] }, { "page": "disconnect", "title": "Close all connections and remove them from the connections cache", "topics": [ "disconnect" ] }, { "page": "is_connected", "title": "Test whether a database is connected", "topics": [ "is_connected", "not_connected" ] }, { "page": "live_connection", "title": "Return the named connection or NULL", "topics": [ "live_connection" ] }, { "page": "prepare_sql", "title": "prepare queries and assemble meta data prior to execution", "topics": [ "prepare_sql" ] }, { "page": "read_sql", "title": "Read a sql file and return it's contents as a tibble", "topics": [ "read_sql" ] }, { "page": "run_files", "title": "Read, prepare and execute .SQL files", "concept": [ "SQL runners" ], "topics": [ "runfiles", "run_files" ] }, { "page": "run_queries", "title": "Execute a sequence of SQL queries", "concept": [ "SQL runners" ], "topics": [ "runqueries", "run_queries" ] }, { "page": "set_default_conn_name", "title": "Set/get the name of the default connection to use", "topics": [ "get_default_conn_name", "set_default_conn_name" ] } ], "_readme": "https://github.com/majerr/sqlhelper/raw/HEAD/README.md", "_rundeps": [ "class", "classInt", "cli", "cpp11", "DBI", "dplyr", "e1071", "generics", "glue", "KernSmooth", "later", "lifecycle", "magrittr", "MASS", "pillar", "pkgconfig", "pool", "proxy", "purrr", "R6", "rappdirs", "Rcpp", "rlang", "s2", "sf", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "units", "utf8", "vctrs", "withr", "wk", "yaml" ], "_vignettes": [ { "source": "execution.Rmd", "filename": "execution.html", "title": "Executing SQL", "engine": "knitr::rmarkdown", "headings": [ "Executing SQL files", "Accessing results of queries", "Controlling execution of individual queries", "Cascaded execution parameters", "Interpolation", "Passing parameter values", "Binding", "Reading and preparing SQL files", "Executing SQL strings", "Passing ad-hoc connections to functions" ], "created": "2024-01-18 14:47:41", "modified": "2024-01-18 14:47:41", "commits": 1 }, { "source": "connections.Rmd", "filename": "connections.html", "title": "Managing Connections", "engine": "knitr::rmarkdown", "headings": [ "Creating connections", "Config files", "The config search path", "Suppressing the config search path", "File precedence, inheritance, and conflicts across config files", "Browsing the connection cache", "Accessing individual connections", "The default connection", "Checking, closing and re-opening connections" ], "created": "2023-01-12 09:41:25", "modified": "2024-01-18 14:47:41", "commits": 4 }, { "source": "sqlhelper.Rmd", "filename": "sqlhelper.html", "title": "sqlhelper", "engine": "knitr::rmarkdown", "headings": [ "Connections", "Executing files", "Executing queries", "Preparing queries" ], "created": "2023-01-12 09:41:25", "modified": "2024-01-18 14:47:41", "commits": 3 }, { "source": "use_case.Rmd", "filename": "use_case.html", "title": "Using sqlhelper in packages", "engine": "knitr::rmarkdown", "headings": [ "Connections", "SQL files", "Exit" ], "created": "2024-01-18 14:47:41", "modified": "2024-01-18 14:47:41", "commits": 1 } ], "_score": 5.369215857410143, "_indexed": true, "_nocasepkg": "sqlhelper", "_universes": [ "majerr" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.2.2", "date": "2026-05-24T07:20:19.000Z", "distro": "noble", "commit": "e79191a22ed638adc61f1b32d9fef9961195026c", "fileid": "1a3ffa76d77423bce7ef702c773c76f427095e6c0c8024d23df9d6b06995851f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236" }, { "r": "4.6.0", "os": "linux", "version": "0.2.2", "date": "2026-05-24T07:20:10.000Z", "distro": "noble", "commit": "e79191a22ed638adc61f1b32d9fef9961195026c", "fileid": "c9f3eb4cc735b38b7f68efa4b9732a7a1d71582008ef05e81e7e3f61020e303c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236" }, { "r": "4.5.3", "os": "mac", "version": "0.2.2", "date": "2026-05-24T07:26:27.000Z", "commit": "e79191a22ed638adc61f1b32d9fef9961195026c", "fileid": "f8efe64c229c30eab5da7874ab0be20e1a80eacfab46c276c29a9dff9fcfc581", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236" }, { "r": "4.6.0", "os": "mac", "version": "0.2.2", "date": "2026-05-24T07:25:40.000Z", "commit": "e79191a22ed638adc61f1b32d9fef9961195026c", "fileid": "19996ab17a35aa9fcd669149347216b3fad03afb99cddf69adcf7abb73e4be9b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236" }, { "r": "4.6.0", "os": "wasm", "version": "0.2.2", "date": "2026-05-24T07:20:18.000Z", "commit": "e79191a22ed638adc61f1b32d9fef9961195026c", "fileid": "65728d3b806774bb6af29b1797a436c63fa77d1444ae78a50fd04b0e6daa5dad", "status": "success", "buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236" }, { "r": "4.7.0", "os": "win", "version": "0.2.2", "date": "2026-05-24T07:19:18.000Z", "commit": "e79191a22ed638adc61f1b32d9fef9961195026c", "fileid": "339042a9fcc99b5818b6c8ab3300c51395f195577c82fcc5172dee637236127e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236" }, { "r": "4.5.3", "os": "win", "version": "0.2.2", "date": "2026-05-24T07:19:08.000Z", "commit": "e79191a22ed638adc61f1b32d9fef9961195026c", "fileid": "cdfe3cb4cb2b19067aace8ed4ba25f93074c579da735f282e360b8577a471b38", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236" }, { "r": "4.6.0", "os": "win", "version": "0.2.2", "date": "2026-05-24T07:21:24.000Z", "commit": "e79191a22ed638adc61f1b32d9fef9961195026c", "fileid": "466efda94b0df913c5d5c604f28165717c7f8caf3ab51dab05dcddb80e8a46b8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/majerr/actions/runs/26354885236" } ] }