{ "_id": "6a1067d0acfb0bcc41ca9430", "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-05-08 05:25:21 UTC", "User": "root" }, "Author": "Arni Magnusson [aut, cre]", "Maintainer": "Arni Magnusson ", "MD5sum": "1f1234cdcdc6d1146ec43dd5c563deff", "_user": "gfcm", "_type": "src", "_file": "MSSQL_1.0.1.tar.gz", "_fileid": "30291c82a1262df6cbd6417b404dc61617ce1990e8c6c024991dc7ba54958080", "_filesize": 143212, "_sha256": "30291c82a1262df6cbd6417b404dc61617ce1990e8c6c024991dc7ba54958080", "_created": "2026-05-08T05:25:21.000Z", "_published": "2026-05-22T14:27:28.853Z", "_distro": "noble", "_jobs": [ { "job": 77399781962, "time": 103, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6872439823" }, { "job": 77399782136, "time": 99, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6872437750" }, { "job": 77399782378, "time": 159, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6872443814" }, { "job": 77399782592, "time": 115, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6872437144" }, { "job": 77399781395, "time": 156, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6872419145" }, { "job": 77399781599, "time": 98, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7162932462" }, { "job": 77399782552, "time": 82, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6872434296" }, { "job": 77399782717, "time": 56, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6872429813" }, { "job": 77399782521, "time": 56, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6872429653" } ], "_buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957", "_status": "success", "_host": "GitHub-Actions", "_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", "uuid": 3720910 }, "_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", "description": "General Fisheries Commission for the Mediterranean - FAO" }, "_downloads": { "count": 231, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/MSSQL" }, "_mentions": 19, "_devurl": "https://github.com/gfcm/mssql", "_searchresults": 2, "_rbuild": "4.6.0", "_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-05-08T05:27:15.000Z", "distro": "noble", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "74d6e63086386eea2e7d5c6627f1ceda7210e20d34e917187f1657518267f8d3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957" }, { "r": "4.6.0", "os": "linux", "version": "1.0.1", "date": "2026-05-08T05:27:05.000Z", "distro": "noble", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "57711d6e0874d68e0d7aefe0c474ec96c80f6d77a97c07b4a33d24edab3d6038", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957" }, { "r": "4.5.3", "os": "mac", "version": "1.0.1", "date": "2026-05-08T05:27:39.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "eccbc70d145f4a467afb61c87b5a85209d7cb2fd70f5bfb6a52fd7ba4f69e551", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957" }, { "r": "4.6.0", "os": "mac", "version": "1.0.1", "date": "2026-05-08T05:27:04.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "a372ff15f7bcfcbe31e2b5a92389b54718a377c98a6be1c4ac4f2d52e4aa7d3a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957" }, { "r": "4.7.0", "os": "win", "version": "1.0.1", "date": "2026-05-08T05:26:42.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "e6e76d6ba9e4910482eef7858463882db14a2525477ce1525faa4511ece875b2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957" }, { "r": "4.5.3", "os": "win", "version": "1.0.1", "date": "2026-05-08T05:26:18.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "16649059922e749dae86f7fc04aded916d3d3d27bfbc4c9350b3856e19c8ce1a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957" }, { "r": "4.6.0", "os": "win", "version": "1.0.1", "date": "2026-05-08T05:26:17.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "fffbf1679e56d61fb54e8d99763630dfa585fa6689b16d96148a6b97eea3bf80", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.1", "date": "2026-05-22T14:27:12.000Z", "commit": "05814335f5a43a2cb929b5dce56e9b9014ba785a", "fileid": "e904e176e87c0751f04a01fab8b734c1a0ab8b90859574acd99566a35efa86be", "status": "success", "buildurl": "https://github.com/r-universe/gfcm/actions/runs/25538447957" } ] }