{ "_id": "6a15b70bacfb0bcc41d6720d", "Package": "sqlserverconnect", "Title": "Simple Helpers for Connecting to 'SQL Server'", "Version": "0.1.0", "Authors@R": "person(\"Dave\", \"Rosenman\", email = \"dave.rosenman.data@gmail.com\", role = c(\"aut\", \"cre\"))", "Description": "Lightweight helpers for connecting to Microsoft 'SQL\nServer' using 'DBI', 'odbc', and 'pool'. Provides simple\nwrappers for building connection arguments, establishing\nconnections, and safely disconnecting.", "URL": "https://drosenman.github.io/sqlserverconnect/,\nhttps://github.com/DRosenman/sqlserverconnect", "BugReports": "https://github.com/DRosenman/sqlserverconnect/issues", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "VignetteBuilder": "knitr", "Config/pak/sysreqs": "make unixodbc-dev", "Repository": "https://drosenman.r-universe.dev", "Date/Publication": "2026-03-28 23:28:23 UTC", "RemoteUrl": "https://github.com/drosenman/sqlserverconnect", "RemoteRef": "HEAD", "RemoteSha": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-26 15:02:08 UTC", "User": "root" }, "Author": "Dave Rosenman [aut, cre]", "Maintainer": "Dave Rosenman ", "MD5sum": "37b52133ac37015b7d5c68394126c397", "_user": "drosenman", "_type": "src", "_file": "sqlserverconnect_0.1.0.tar.gz", "_fileid": "93847ac51dfb537afd9371604a0c4860cf67980967cd94f7a796016075d84f75", "_filesize": 91923, "_sha256": "93847ac51dfb537afd9371604a0c4860cf67980967cd94f7a796016075d84f75", "_created": "2026-05-26T15:02:08.000Z", "_published": "2026-05-26T15:06:51.148Z", "_distro": "noble", "_jobs": [ { "job": 77891835262, "time": 126, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7218245357" }, { "job": 77891835013, "time": 127, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7218245619" }, { "job": 77891834939, "time": 135, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7218281417" }, { "job": 77891835036, "time": 156, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7218282937" }, { "job": 77891239281, "time": 154, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7218189982" }, { "job": 77891834971, "time": 105, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7218236833" }, { "job": 77891835243, "time": 82, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7218226707" }, { "job": 77891834842, "time": 73, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7218222747" }, { "job": 77891835100, "time": 80, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7218226457" } ], "_buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/drosenman/sqlserverconnect", "_commit": { "id": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "author": "Dave Rosenman ", "committer": "Dave Rosenman ", "message": "added vignettes\n", "time": 1774740503 }, "_maintainer": { "name": "Dave Rosenman", "email": "dave.rosenman.data@gmail.com", "login": "drosenman", "linkedin": "in/dave-rosenman", "description": "Data & Software Engineer building end-to-end analytical systems and apps. TCNJ Physics Class of 2017. Working on Georgia Tech Masters in Comp Science, AI Focus.", "uuid": 20256852 }, "_registered": true, "_dependencies": [ { "package": "DBI", "role": "Imports" }, { "package": "odbc", "role": "Imports" }, { "package": "pool", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "drosenman", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-06", "n": 5 }, { "week": "2026-07", "n": 1 }, { "week": "2026-08", "n": 1 }, { "week": "2026-13", "n": 4 } ], "_tags": [], "_stars": 0, "_contributors": [ { "user": "drosenman", "count": 11, "uuid": 20256852 } ], "_userbio": { "uuid": 20256852, "type": "user", "name": "Dave Rosenman", "description": "Data & Software Engineer building end-to-end analytical systems and apps. TCNJ Physics Class of 2017. Working on Georgia Tech Masters in Comp Science, AI Focus." }, "_downloads": { "count": 139, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlserverconnect" }, "_devurl": "https://github.com/drosenman/sqlserverconnect", "_pkgdown": "https://drosenman.github.io/sqlserverconnect/", "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/readme.html", "extra/readme.md", "extra/sqlserverconnect.html", "manual.pdf" ], "_homeurl": "https://github.com/drosenman/sqlserverconnect", "_realowner": "drosenman", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-02-16" } ], "_exports": [ "db_connect", "db_connection_args", "db_disconnect" ], "_help": [ { "page": "db_connect", "title": "Connect to a SQL Server database", "topics": [ "db_connect" ] }, { "page": "db_connection_args", "title": "Build SQL Server connection arguments", "topics": [ "db_connection_args" ] }, { "page": "db_disconnect", "title": "Disconnect from a SQL Server connection or pool", "topics": [ "db_disconnect" ] } ], "_readme": "https://github.com/drosenman/sqlserverconnect/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "blob", "cli", "DBI", "glue", "hms", "later", "lifecycle", "odbc", "pkgconfig", "pool", "R6", "Rcpp", "rlang", "vctrs" ], "_vignettes": [ { "source": "getting-started.Rmd", "filename": "getting-started.html", "title": "Getting Started with sqlserverconnect", "engine": "knitr::rmarkdown", "headings": [ "Overview", "Windows Authentication (trusted connection)", "SQL Server Authentication (username + password)", "Inspecting connection arguments", "Custom port", "Named instances" ], "created": "2026-03-28 23:28:23", "modified": "2026-03-28 23:28:23", "commits": 1 }, { "source": "shiny.Rmd", "filename": "shiny.html", "title": "Using sqlserverconnect with Shiny", "engine": "knitr::rmarkdown", "headings": [ "Why use connection pools in Shiny?", "DBI vs pool: when to use which?", "Basic Shiny setup", "Key points", "Reactive queries" ], "created": "2026-03-28 23:28:23", "modified": "2026-03-28 23:28:23", "commits": 1 } ], "_score": 4.6020599913279625, "_indexed": true, "_nocasepkg": "sqlserverconnect", "_universes": [ "drosenman" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-05-26T15:04:19.000Z", "distro": "noble", "commit": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "fileid": "41de7538f0cef44bee41d796fca5a210f5e5c41c12ee0bda3ae7a17afe26b0e2", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-05-26T15:04:17.000Z", "distro": "noble", "commit": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "fileid": "78f0f219d409fe3e1a0f1ba1ff81d499caf1a8603e26eddf20520fea579d7dcd", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-05-26T15:05:47.000Z", "commit": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "fileid": "ae0e3803cf7f68dcdab6f0508ec19cb048942f2d79843d358ed936a4d5553cb2", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-05-26T15:05:49.000Z", "commit": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "fileid": "d508e75bedb49d197026c07eab3d6b3ec21d0f393f6675ef691b4f08547bc486", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-05-26T15:04:08.000Z", "commit": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "fileid": "8b6343d39e9017436c60284879fe215691e85ee4a0e551f10c46631ca01dd535", "status": "success", "buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-05-26T15:03:29.000Z", "commit": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "fileid": "ebea5ea7a5294cfe66aab9ed6e8a956f41351bde4d6dd99ce26817a9764f8289", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-05-26T15:03:20.000Z", "commit": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "fileid": "c7a762147679b654dc0f2853d3cc8437a3947033f5c3a706c13610b5d9b32d6a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-05-26T15:03:27.000Z", "commit": "4e3b9079048388c2c1b74e84d3334d2fb5745450", "fileid": "ec7547a44d0dc29b91ee1f1e9d8d7d4ba035fb4801d6f963989d309d7cc1ef50", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/drosenman/actions/runs/26456303884" } ] }