{ "_id": "6ae1baec327abcdf8686433f", "Package": "RMySQL", "Version": "0.11.3", "Title": "Database Interface and 'MySQL' Driver for R", "Description": "Legacy 'DBI' interface to 'MySQL' / 'MariaDB' based on old\ncode ported from S-PLUS. A modern 'MySQL' client written in\n'C++' is available from the 'RMariaDB' package.", "Authors@R": "c(person(\"Jeroen\", \"Ooms\", email = \"jeroenooms@gmail.com\", \nrole = c(\"aut\", \"cre\"), comment = c(ORCID = \"0000-0002-4035-0289\")),\nperson(\"David\", \"James\", role = \"aut\"),\nperson(\"Saikat\", \"DebRoy\", role = \"aut\"),\nperson(\"Hadley\", \"Wickham\", email = \"hadley@rstudio.com\", role = \"aut\"),\nperson(\"Jeffrey\", \"Horner\", role = \"aut\"),\nperson(\"RStudio\", role = \"cph\"))", "License": "GPL-2", "URL": "https://r-dbi.r-universe.dev/RMySQL\nhttps://downloads.mariadb.org/connector-c/", "BugReports": "https://github.com/r-dbi/rmysql/issues", "SystemRequirements": "libmariadb-client-dev | libmariadb-client-lgpl-dev\n| libmysqlclient-dev (deb), mariadb-devel (rpm), mariadb |\nmysql-connector-c (brew), mysql56_dev (csw)", "NeedsCompilation": "yes", "Collate": "'mysql.R' 'driver.R' 'connection.R' 'data-type.R' 'default.R'\n'escaping.R' 'result.R' 'extension.R' 'is-valid.R' 'table.R'\n'transaction.R'", "RoxygenNote": "7.3.2.9000", "Packaged": { "Date": "2026-10-28 08:57:34 UTC", "User": "root" }, "Author": "Jeroen Ooms [aut, cre] (ORCID:\n), David James [aut],\nSaikat DebRoy [aut], Hadley Wickham [aut], Jeffrey Horner\n[aut], RStudio [cph]", "Maintainer": "Jeroen Ooms ", "Config/pak/sysreqs": "libmysqlclient-dev", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2026-04-11 13:33:07 UTC", "RemoteUrl": "https://github.com/cran/RMySQL", "RemoteRef": "HEAD", "RemoteSha": "c42097e2aca7b9614c5483de83b0aa333134363b", "_user": "cran", "_type": "src", "_file": "RMySQL_0.11.3.tar.gz", "_fileid": "https://r2.ropensci.org/4ae62284e918570eb406fb6e4e658fc7c11bc2af1e8fb52d96586c8a0cafb6e9", "_filesize": 200756, "_sha256": "4ae62284e918570eb406fb6e4e658fc7c11bc2af1e8fb52d96586c8a0cafb6e9", "_expires": "2027-02-05T09:05:03.000Z", "_created": "2026-10-28T08:57:34.000Z", "_published": "2026-10-28T09:05:48.074Z", "_upstream": "https://github.com/cran/RMySQL", "_status": "success", "_maintainer": { "name": "Jeroen Ooms", "email": "jeroenooms@gmail.com", "login": "jeroen", "mastodon": "@jeroenooms@fosstodon.org", "bluesky": "@jeroenooms.bsky.social", "description": "Staff research engineer at @ropensci, tidyverse team member, and project lead for R-universe", "uuid": 216319, "orcid": "0000-0002-4035-0289" }, "_jobs": [ { "job": 122722363939, "time": 83, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "12803418417" }, { "job": 122722363985, "time": 394, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12804490920" }, { "job": 122722364128, "time": 83, "config": "linux-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12802974833" }, { "job": 122722363958, "time": 197, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12803826259" }, { "job": 122720905407, "time": 213, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12803359836" }, { "job": 122722363898, "time": 85, "config": "wasm-release", "r": "4.6.0", "check": "FAIL", "artifact": "" }, { "job": 122722363945, "time": 288, "config": "windows-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "12804650265" }, { "job": 122722363908, "time": 408, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12803653219" }, { "job": 122722364010, "time": 249, "config": "windows-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12803632866" }, { "job": 122722363974, "time": 149, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12803074491" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387", "_commit": { "id": "c42097e2aca7b9614c5483de83b0aa333134363b", "author": "Jeroen Ooms ", "committer": "cran-robot ", "message": "version 0.11.3\n", "time": 1775914387 }, "_distro": "resolute", "_host": "GitHub-Actions", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 2.8.0", "role": "Depends" }, { "package": "DBI", "version": ">= 0.4", "role": "Depends" }, { "package": "methods", "role": "Imports" }, { "package": "testthat", "role": "Suggests" }, { "package": "curl", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 11, "_updates": [ { "week": "2026-10", "n": 1 }, { "week": "2026-15", "n": 1 } ], "_tags": [ { "name": "0.11.2", "date": "2026-03-02" }, { "name": "0.11.3", "date": "2026-04-11" } ], "_stars": 3, "_contributors": [ { "user": "jeroen", "count": 34, "uuid": 216319 }, { "user": "daj025", "count": 4, "uuid": 13022669 }, { "user": "jeffreyhorner", "count": 4, "uuid": 306214 } ], "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 634, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 25788, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RMySQL" }, "_mentions": 24, "_devurl": "https://github.com/r-dbi/rmysql", "_searchresults": 8, "_topics": [ "mysql" ], "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/RMySQL.html" ], "_homeurl": "https://github.com/r-dbi/rmysql", "_realowner": "r-dbi", "_cranurl": false, "_releases": [ { "version": "0.2", "date": "2000-02-04" }, { "version": "0.2-3", "date": "2000-10-06" }, { "version": "0.4-2", "date": "2001-03-12" }, { "version": "0.4-3", "date": "2001-11-06" }, { "version": "0.4-5", "date": "2002-05-21" }, { "version": "0.4-6", "date": "2002-06-27" }, { "version": "0.5-0", "date": "2002-10-01" }, { "version": "0.5-1", "date": "2003-04-07" }, { "version": "0.5-2", "date": "2003-05-17" }, { "version": "0.5-3", "date": "2003-12-02" }, { "version": "0.5-4", "date": "2004-04-13" }, { "version": "0.5-5", "date": "2004-06-22" }, { "version": "0.5-7", "date": "2006-01-28" }, { "version": "0.5-9", "date": "2006-10-07" }, { "version": "0.5-10", "date": "2006-10-27" }, { "version": "0.5-11", "date": "2007-01-05" }, { "version": "0.6-0", "date": "2007-06-01" }, { "version": "0.6-1", "date": "2008-09-08" }, { "version": "0.7-2", "date": "2008-12-05" }, { "version": "0.7-3", "date": "2009-02-04" }, { "version": "0.7-4", "date": "2009-04-14" }, { "version": "0.7-5", "date": "2010-07-24" }, { "version": "0.8-0", "date": "2011-06-09" }, { "version": "0.9-0", "date": "2012-01-14" }, { "version": "0.9-3", "date": "2012-01-17" }, { "version": "0.10", "date": "2015-01-05" }, { "version": "0.10.1", "date": "2015-01-15" }, { "version": "0.10.2", "date": "2015-02-24" }, { "version": "0.10.3", "date": "2015-04-21" }, { "version": "0.10.4", "date": "2015-07-28" }, { "version": "0.10.5", "date": "2015-08-25" }, { "version": "0.10.6", "date": "2015-09-05" }, { "version": "0.10.7", "date": "2015-10-27" }, { "version": "0.10.8", "date": "2016-01-28" }, { "version": "0.10.9", "date": "2016-05-08" }, { "version": "0.10.10", "date": "2017-03-21" }, { "version": "0.10.11", "date": "2017-03-29" }, { "version": "0.10.12", "date": "2017-07-06" }, { "version": "0.10.13", "date": "2017-08-14" }, { "version": "0.10.14", "date": "2018-02-26" }, { "version": "0.10.15", "date": "2018-05-13" }, { "version": "0.10.16", "date": "2019-01-04" }, { "version": "0.10.17", "date": "2019-03-05" }, { "version": "0.10.18", "date": "2019-12-14" }, { "version": "0.10.19", "date": "2020-02-03" }, { "version": "0.10.20", "date": "2020-03-14" }, { "version": "0.10.21", "date": "2020-12-16" }, { "version": "0.10.22", "date": "2021-06-22" }, { "version": "0.10.23", "date": "2021-12-14" }, { "version": "0.10.24", "date": "2022-10-18" }, { "version": "0.10.25", "date": "2022-12-06" }, { "version": "0.10.26", "date": "2023-09-26" }, { "version": "0.10.27", "date": "2023-12-04" }, { "version": "0.10.28", "date": "2024-08-22" }, { "version": "0.10.29", "date": "2024-10-04" }, { "version": "0.11.0", "date": "2025-02-08" }, { "version": "0.11.1", "date": "2025-04-01" }, { "version": "0.11.2", "date": "2026-03-02" }, { "version": "0.11.3", "date": "2026-04-11" } ], "_exports": [ "CLIENT_COMPRESS", "CLIENT_CONNECT_WITH_DB", "CLIENT_FOUND_ROWS", "CLIENT_IGNORE_SIGPIPE", "CLIENT_IGNORE_SPACE", "CLIENT_INTERACTIVE", "CLIENT_LOCAL_FILES", "CLIENT_LONG_FLAG", "CLIENT_LONG_PASSWORD", "CLIENT_MULTI_RESULTS", "CLIENT_MULTI_STATEMENTS", "CLIENT_NO_SCHEMA", "CLIENT_ODBC", "CLIENT_PROTOCOL_41", "CLIENT_RESERVED", "CLIENT_SECURE_CONNECTION", "CLIENT_SSL", "CLIENT_TRANSACTIONS", "dbApply", "dbBegin", "dbClearResult", "dbColumnInfo", "dbCommit", "dbConnect", "dbDataType", "dbDisconnect", "dbEscapeStrings", "dbExistsTable", "dbFetch", "dbGetException", "dbGetInfo", "dbGetRowCount", "dbGetRowsAffected", "dbGetStatement", "dbHasCompleted", "dbIsValid", "dbListConnections", "dbListFields", "dbListResults", "dbListTables", "dbMoreResults", "dbNextResult", "dbQuoteIdentifier", "dbReadTable", "dbRemoveTable", "dbRollback", "dbSendQuery", "dbUnloadDriver", "dbWriteTable", "fetch", "isIdCurrent", "isSQLKeyword", "make.db.names", "MySQL", "mysqlBuildTableDefinition", "mysqlClientLibraryVersions", "mysqlHasDefault", "show", "SQLKeywords", "summary" ], "_help": [ { "page": "constants", "title": "Constants", "topics": [ ".MySQLPkgName", ".MySQLPkgRCS", ".MySQLPkgVersion", ".MySQLSQLKeywords", "CLIENT_COMPRESS", "CLIENT_CONNECT_WITH_DB", "CLIENT_FOUND_ROWS", "CLIENT_IGNORE_SIGPIPE", "CLIENT_IGNORE_SPACE", "CLIENT_INTERACTIVE", "CLIENT_LOCAL_FILES", "CLIENT_LONG_FLAG", "CLIENT_LONG_PASSWORD", "CLIENT_MULTI_RESULTS", "CLIENT_MULTI_STATEMENTS", "CLIENT_NO_SCHEMA", "CLIENT_ODBC", "CLIENT_PROTOCOL_41", "CLIENT_RESERVED", "CLIENT_SECURE_CONNECTION", "CLIENT_SSL", "CLIENT_TRANSACTIONS", "constants" ] }, { "page": "db-meta", "title": "Database interface meta-data", "topics": [ "db-meta", "dbGetException,MySQLConnection-method", "dbGetInfo,MySQLConnection-method", "dbListResults,MySQLConnection-method", "show,MySQLConnection-method", "summary,MySQLConnection-method" ] }, { "page": "dbApply", "title": "Apply R/S-Plus functions to remote groups of DBMS rows (experimental)", "topics": [ "dbApply", "dbApply,MySQLResult-method" ] }, { "page": "dbConnect-MySQLDriver-method", "title": "Connect/disconnect to a MySQL DBMS", "topics": [ "dbConnect,MySQLConnection-method", "dbConnect,MySQLDriver-method", "dbDisconnect,MySQLConnection-method" ] }, { "page": "dbDataType-MySQLDriver-method", "title": "Determine the SQL Data Type of an S object", "topics": [ "dbDataType,MySQLConnection-method", "dbDataType,MySQLDriver-method" ] }, { "page": "dbEscapeStrings", "title": "Escape SQL-special characters in strings.", "topics": [ "dbEscapeStrings", "dbEscapeStrings,MySQLConnection,character-method", "dbEscapeStrings,MySQLResult,character-method" ] }, { "page": "query", "title": "Execute a SQL statement on a database connection.", "topics": [ "dbClearResult,MySQLResult-method", "dbFetch,MySQLResult,missing-method", "dbFetch,MySQLResult,numeric-method", "dbGetInfo,MySQLResult-method", "dbGetStatement,MySQLResult-method", "dbListFields,MySQLResult,missing-method", "dbSendQuery,MySQLConnection,character-method", "fetch,MySQLResult,missing-method", "fetch,MySQLResult,numeric-method" ] }, { "page": "dbGetInfo-MySQLDriver-method", "title": "Get information about a MySQL driver.", "topics": [ "dbGetInfo,MySQLDriver-method", "dbListConnections,MySQLDriver-method", "show,MySQLDriver-method", "summary,MySQLDriver-method" ] }, { "page": "dbNextResult", "title": "Fetch next result set from an SQL script or stored procedure (experimental)", "topics": [ "dbMoreResults", "dbMoreResults,MySQLConnection-method", "dbNextResult", "dbNextResult,MySQLConnection-method" ] }, { "page": "dbReadTable", "title": "Convenience functions for importing/exporting DBMS tables", "topics": [ "dbExistsTable,MySQLConnection,character-method", "dbListFields,MySQLConnection,character-method", "dbListTables,MySQLConnection-method", "dbReadTable,MySQLConnection,character-method", "dbRemoveTable,MySQLConnection,character-method" ] }, { "page": "dbUnloadDriver-MySQLDriver-method", "title": "Unload MySQL driver.", "topics": [ "dbUnloadDriver,MySQLDriver-method" ] }, { "page": "dbWriteTable", "title": "Write a local data frame or file to the database.", "topics": [ "dbWriteTable,MySQLConnection,character,character-method", "dbWriteTable,MySQLConnection,character,data.frame-method" ] }, { "page": "isIdCurrent", "title": "Check if a database object is valid.", "topics": [ "dbIsValid,MySQLConnection-method", "dbIsValid,MySQLDriver-method", "dbIsValid,MySQLResult-method", "isIdCurrent" ] }, { "page": "make.db.names-MySQLConnection-character-method", "title": "Make R/S-Plus identifiers into legal SQL identifiers", "topics": [ "isSQLKeyword,MySQLConnection,character-method", "make.db.names,MySQLConnection,character-method", "SQLKeywords,MySQLConnection-method" ] }, { "page": "mysqlClientLibraryVersions", "title": "MySQL Check for Compiled Versus Loaded Client Library Versions", "topics": [ "mysqlClientLibraryVersions" ] }, { "page": "MySQLDriver-class", "title": "Class MySQLDriver with constructor MySQL.", "topics": [ "RMySQL-package", "MySQL", "MySQLDriver-class", "RMySQL" ] }, { "page": "mysqlHasDefault", "title": "Check if default database is available.", "topics": [ "mysqlHasDefault" ] }, { "page": "result-meta", "title": "Database interface meta-data.", "topics": [ "dbColumnInfo,MySQLResult-method", "dbGetException,MySQLResult-method", "dbGetRowCount,MySQLResult-method", "dbGetRowsAffected,MySQLResult-method", "dbHasCompleted,MySQLResult-method", "result-meta", "show,MySQLResult-method", "summary,MySQLResult-method" ] }, { "page": "transactions", "title": "DBMS Transaction Management", "topics": [ "dbBegin,MySQLConnection-method", "dbCommit,MySQLConnection-method", "dbRollback,MySQLConnection-method", "transactions" ] } ], "_rundeps": [ "DBI" ], "_sysdeps": [ { "shlib": "libmysqlclient", "package": "libmysqlclient24", "headers": "libmysqlclient-dev", "source": "mysql", "version": "8.4.11-0ubuntu0.26.04.1", "name": "mysql", "homepage": "http://dev.mysql.com/", "description": "MySQL database client library" } ], "_score": 6.00911284746458, "_indexed": false, "_nocasepkg": "rmysql", "_universes": [ "cran" ], "_indexurl": "https://r-dbi.r-universe.dev/RMySQL", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.11.3", "date": "2026-10-28T08:59:10.000Z", "distro": "resolute", "arch": "aarch64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "https://r2.ropensci.org/25aad62c2dbb82ebf592c9b1e85ae902fa95ccd46c3e1a8d45d88ea4d679aa20", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387" }, { "r": "4.7.0", "os": "linux", "version": "0.11.3", "date": "2026-10-28T09:02:52.000Z", "distro": "resolute", "arch": "x86_64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "https://r2.ropensci.org/fb0ecde8e16ba007de2183900e286dc2371fcdb3d319b98a7d513a9ef8346cfe", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387" }, { "r": "4.6.1", "os": "linux", "version": "0.11.3", "date": "2026-10-28T08:59:12.000Z", "distro": "resolute", "arch": "aarch64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "https://r2.ropensci.org/a640a75a9c0f57cb2c828075de7bc366b49472aabba81b9abd4c9bf04723b397", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387" }, { "r": "4.6.1", "os": "linux", "version": "0.11.3", "date": "2026-10-28T09:00:06.000Z", "distro": "resolute", "arch": "x86_64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "https://r2.ropensci.org/2a85cc2ab66c6dcc344fd4cd516ea6b76cd772ec10978be9b2547a6f8bf365da", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387" }, { "r": "4.7.0", "os": "win", "version": "0.11.3", "date": "2026-10-28T09:01:12.000Z", "arch": "aarch64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "https://r2.ropensci.org/9d7fe8916b5519fd5669ab946c9a767e8c8113cc93e6d62561579c620c8ce695", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387" }, { "r": "4.7.0", "os": "win", "version": "0.11.3", "date": "2026-10-28T09:01:58.000Z", "arch": "x86_64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "https://r2.ropensci.org/835141e4a2a8309922c61a2a0c7644951e8d6b4aa8dec2777ff36b14e79ec960", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387" }, { "r": "4.6.1", "os": "win", "version": "0.11.3", "date": "2026-10-28T09:00:35.000Z", "arch": "aarch64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "https://r2.ropensci.org/f0f1c6edbbf5bfd0f6d4a6f1f3f056b07aa2d65038c51b64dd2c7934dcba57ae", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387" }, { "r": "4.6.1", "os": "win", "version": "0.11.3", "date": "2026-10-28T08:58:50.000Z", "arch": "x86_64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "https://r2.ropensci.org/f3ab8aa42cddf615498c332938ca41cc8a4e984078ba0d745b963919fba38529", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/40660110387" } ] }