{ "_id": "6ac37b937d74fca524f997d3", "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-10-05 10:23:20 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/0f9822dcf9aa7c340f9445d4438c0a184d19d64580483c8b4236658a8e42f4df", "_filesize": 143915, "_sha256": "0f9822dcf9aa7c340f9445d4438c0a184d19d64580483c8b4236658a8e42f4df", "_expires": "2027-01-13T10:27:29.000Z", "_created": "2026-10-05T10:23:20.000Z", "_published": "2026-10-05T10:27:31.556Z", "_jobs": [ { "job": 111718173964, "time": 90, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11339105608" }, { "job": 111718173853, "time": 95, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11338498626" }, { "job": 111718173906, "time": 205, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11338383895" }, { "job": 111718173863, "time": 172, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11339571013" }, { "job": 111717393239, "time": 131, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11337844625" }, { "job": 111718173810, "time": 75, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11338688065" }, { "job": 111718173952, "time": 60, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11339425920" }, { "job": 111718173937, "time": 78, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11338259039" }, { "job": 111718174016, "time": 83, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11337944688" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018", "_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": 286, "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/manual.pdf", "extra/MSSQL.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md" ], "_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-10-05T10:26:02.000Z", "distro": "resolute", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/77f8046eaa993b26cf5509e5d19568de7b3a6980330e17513afea5956597a237", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018" }, { "r": "4.6.1", "os": "linux", "version": "1.0.1", "date": "2026-10-05T10:25:05.000Z", "distro": "resolute", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/32405e6697e4959f21127b433a3ab699637ea6f2db3f1e95dc5808b4a957b89a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018" }, { "r": "4.5.3", "os": "mac", "version": "1.0.1", "date": "2026-10-05T10:26:19.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/55c42413cd5a273f292b87542bab73f6a1829e1eb005b9445303684e256bbd99", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018" }, { "r": "4.6.1", "os": "mac", "version": "1.0.1", "date": "2026-10-05T10:25:41.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/4322946b85149a69286b8169fd65d6adf9b9f534d0fc4bbbad6617a6a89abecc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.1", "date": "2026-10-05T10:25:50.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/66cb153ae8f49c716b388020e485b91b4e7fd59eb6ca9f7a3fe37368db98b63e", "status": "success", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018" }, { "r": "4.7.0", "os": "win", "version": "1.0.1", "date": "2026-10-05T10:24:20.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/dce9379a566872769630d4b9a5858548588b0ac3215608fcced8cc5572ffdc8d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018" }, { "r": "4.5.3", "os": "win", "version": "1.0.1", "date": "2026-10-05T10:24:42.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/d118aa2cfd3a0d353b6fd7e5cc664adbd36ad6a2bfcb0a2b1f5524a514805bbd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018" }, { "r": "4.6.1", "os": "win", "version": "1.0.1", "date": "2026-10-05T10:24:44.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "https://r2.ropensci.org/7618d7847219d44ea284e3108f2739b5d9a456d0f0c8519a72189ba626cefb56", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/37295898018" } ] }