{ "_id": "6a294118732311cd875aa097", "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-06-10 10:45:36 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", "MD5sum": "bde205e639180886997dafa21f4578fc", "_user": "cran", "_type": "src", "_file": "RMySQL_0.11.3.tar.gz", "_fileid": "238868370b7e0dbc1506c911bbd0a10a126268af07516d7dffcfb61a7d59a41b", "_filesize": 199477, "_sha256": "238868370b7e0dbc1506c911bbd0a10a126268af07516d7dffcfb61a7d59a41b", "_created": "2026-06-10T10:45:36.000Z", "_published": "2026-06-10T10:48:56.818Z", "_distro": "noble", "_jobs": [ { "job": 80539751353, "time": 125, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7533488974" }, { "job": 80539751350, "time": 158, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7533499089" }, { "job": 80539751391, "time": 123, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7533486812" }, { "job": 80539751327, "time": 162, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7533500157" }, { "job": 80539060705, "time": 238, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7533443148" }, { "job": 80539751325, "time": 102, "config": "wasm-release", "r": "4.6.0", "check": "FAIL", "artifact": "" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/27270664779", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/RMySQL", "_commit": { "id": "c42097e2aca7b9614c5483de83b0aa333134363b", "author": "Jeroen Ooms ", "committer": "cran-robot ", "message": "version 0.11.3\n", "time": 1775914387 }, "_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" }, "_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": 15, "_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", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 39340, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RMySQL" }, "_mentions": 24, "_devurl": "https://github.com/r-dbi/rmysql", "_searchresults": 4376, "_topics": [ "mysql" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/RMySQL.html", "manual.pdf" ], "_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": "libmysqlclient21", "headers": "libmysqlclient-dev", "source": "mysql", "version": "8.0.46-0ubuntu0.24.04.2", "name": "mysql", "homepage": "http://dev.mysql.com/", "description": "MySQL database client library" } ], "_score": 8.96830542873166, "_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-06-10T10:47:58.000Z", "distro": "noble", "arch": "aarch64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "bfc3b375f7df39471238e928d81f83e2a2f2d0bcfa7acd20ae47005e6e4e2059", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27270664779" }, { "r": "4.7.0", "os": "linux", "version": "0.11.3", "date": "2026-06-10T10:48:22.000Z", "distro": "noble", "arch": "x86_64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "bfc49d265b1836c0b8b12092efa4b1eb1bd37348d6954c249291901d399a2a80", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27270664779" }, { "r": "4.6.0", "os": "linux", "version": "0.11.3", "date": "2026-06-10T10:47:50.000Z", "distro": "noble", "arch": "aarch64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "7723b47a3c9dbe1ea3e31f4177e4170c02f1aecd566fc207880067c0cf5968fe", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27270664779" }, { "r": "4.6.0", "os": "linux", "version": "0.11.3", "date": "2026-06-10T10:48:24.000Z", "distro": "noble", "arch": "x86_64", "commit": "c42097e2aca7b9614c5483de83b0aa333134363b", "fileid": "1e5705132f7cd3f821262c73003f2213684b7e8029cb5f3093db6bea3e4ed35d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/27270664779" } ] }