{ "_id": "6a4cc7a414a7e894f5e57b83", "Package": "MSSQL", "Version": "1.0.1", "Date": "2024-10-22", "Title": "Tools to Work with Microsoft SQL Server Databases via 'RODBC'", "Authors@R": "c(person(\"Arni\", \"Magnusson\", role=c(\"aut\",\"cre\"), email=\"thisisarni@gmail.com\"))", "Description": "Tools that extend the functionality of the 'RODBC' package\nto work with Microsoft SQL Server databases. Makes it easier to\nbrowse the database and examine individual tables and views.", "License": "GPL-3", "URL": "https://github.com/gfcm/MSSQL", "Encoding": "UTF-8", "RoxygenNote": "7.3.2", "Roxygen": "list(old_usage=TRUE)", "Config/pak/sysreqs": "unixodbc-dev", "Repository": "https://gfcm.r-universe.dev", "Date/Publication": "2024-10-22 02:04:52 UTC", "RemoteUrl": "https://github.com/gfcm/mssql", "RemoteRef": "HEAD", "RemoteSha": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-07 09:29:01 UTC", "User": "root" }, "Author": "Arni Magnusson [aut, cre]", "Maintainer": "Arni Magnusson ", "_user": "gfcm", "_type": "src", "_file": "MSSQL_1.0.1.tar.gz", "_fileid": "https://r2.ropensci.org/c784e5c6fc11a104734cebc3d72431d3801d93c82a8fa5f6ae92219705d578c0", "_filesize": 143704, "_sha256": "c784e5c6fc11a104734cebc3d72431d3801d93c82a8fa5f6ae92219705d578c0", "_expires": "2026-10-15T09:32:19.000Z", "_created": "2026-07-07T09:29:01.000Z", "_published": "2026-07-07T09:32:20.698Z", "_jobs": [ { "job": 85582684609, "time": 104, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8133654008" }, { "job": 85582684604, "time": 115, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8133657659" }, { "job": 85582684638, "time": 166, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8133665185" }, { "job": 85582684728, "time": 109, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8133649007" }, { "job": 85582164945, "time": 159, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8133610840" }, { "job": 85582684617, "time": 95, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8133650659" }, { "job": 85582684659, "time": 69, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8133640219" }, { "job": 85582684674, "time": 51, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8133632907" }, { "job": 85582684677, "time": 59, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8133635657" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890", "_status": "success", "_upstream": "https://github.com/gfcm/mssql", "_commit": { "id": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "author": "Arni Magnusson ", "committer": "Arni Magnusson ", "message": "Bump date\n", "time": 1729562692 }, "_maintainer": { "name": "Arni Magnusson", "email": "thisisarni@gmail.com", "login": "arni-magnusson", "description": "", "uuid": 3720910 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "RODBC", "role": "Imports" } ], "_owner": "gfcm", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 2, "_contributors": [ { "user": "arni-magnusson", "count": 11, "uuid": 3720910 } ], "_userbio": { "uuid": 72981884, "type": "organization", "name": "GFCM", "followers": 5, "description": "General Fisheries Commission for the Mediterranean - FAO" }, "_downloads": { "count": 241, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/MSSQL" }, "_mentions": 19, "_devurl": "https://github.com/gfcm/mssql", "_searchresults": 2, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/MSSQL.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/gfcm/mssql", "_realowner": "gfcm", "_cranurl": true, "_releases": [ { "version": "1.0.0", "date": "2021-03-10" }, { "version": "1.0.1", "date": "2024-10-22" } ], "_exports": [ "dbOverview", "dbStorage", "dbTime", "tableDim", "tableHead", "tableNcol", "tableNrow", "tableOverview", "tableQuote" ], "_help": [ { "page": "MSSQL-package", "title": "Tools to Work with Microsoft SQL Server Databases via RODBC", "topics": [ "MSSQL-package", "MSSQL" ] }, { "page": "dbOverview", "title": "Overview of Tables and Views", "topics": [ "dbOverview" ] }, { "page": "dbStorage", "title": "Storage Size", "topics": [ "dbStorage" ] }, { "page": "dbTime", "title": "Time Created and Modified", "topics": [ "dbTime" ] }, { "page": "tableDim", "title": "Table Dimensions", "topics": [ "tableDim" ] }, { "page": "tableHead", "title": "First Rows", "topics": [ "tableHead" ] }, { "page": "tableNcol", "title": "Number of Columns", "topics": [ "tableNcol" ] }, { "page": "tableNrow", "title": "Number of Rows", "topics": [ "tableNrow" ] }, { "page": "tableOverview", "title": "Data Types and Dimensions", "topics": [ "tableOverview" ] }, { "page": "tableQuote", "title": "Quote Table Name", "topics": [ "tableQuote" ] } ], "_readme": "https://github.com/gfcm/mssql/raw/HEAD/README.md", "_rundeps": [ "RODBC" ], "_vignettes": [ { "source": "implementation.Rnw", "filename": "implementation.pdf", "title": "Implementation Notes", "engine": "utils::Sweave", "headings": [], "created": "2020-11-09 17:31:08", "modified": "2020-11-09 17:31:08", "commits": 1 } ], "_score": 5, "_indexed": true, "_nocasepkg": "mssql", "_universes": [ "gfcm", "arni-magnusson" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.1", "date": "2026-07-07T09:30:51.000Z", "distro": "resolute", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/c870cb28463577112a51b2cae28c172110366cd05be19c05bfcfaca63632f81d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890" }, { "r": "4.6.1", "os": "linux", "version": "1.0.1", "date": "2026-07-07T09:30:58.000Z", "distro": "resolute", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/6d875305e37e3c55735bca92b437fe15ae40e4a46e39533920e287dbfea8dd4e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890" }, { "r": "4.5.3", "os": "mac", "version": "1.0.1", "date": "2026-07-07T09:31:18.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/12dced00c2ae37c18966033832777ba81c48cc983d89b7b4a6cf97ca8923d239", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890" }, { "r": "4.6.1", "os": "mac", "version": "1.0.1", "date": "2026-07-07T09:30:41.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/a7dbde907cf3cc12d237bfff706948eef63b32ca89775d4a80ff20a77674130a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.1", "date": "2026-07-07T09:30:51.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/59d22022ef4ed20d9fe16031e5e80321c4226fcccd78ab599177991cb4b4c495", "status": "success", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890" }, { "r": "4.7.0", "os": "win", "version": "1.0.1", "date": "2026-07-07T09:30:13.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/4c2a63ce3c08a983009073cf68a179bd25f875d953dff4dec1646ab324c6cf04", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890" }, { "r": "4.5.3", "os": "win", "version": "1.0.1", "date": "2026-07-07T09:29:55.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/f17a6d78a87fe0acb13cc1cf7491cff88f91608eefaf197d3b01fc79af0516b0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890" }, { "r": "4.6.1", "os": "win", "version": "1.0.1", "date": "2026-07-07T09:30:02.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/eff0e4531cec6bb34b08fb3973fc59125f4f4e87f79d455d692cd4e12d3e64f1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/28855840890" } ] }