{ "_id": "6a12a24bacfb0bcc41d11c2b", "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", "Config/pak/sysreqs": "libmysqlclient-dev", "Repository": "https://r-dbi.r-universe.dev", "Date/Publication": "2026-04-11 11:57:36 UTC", "RemoteUrl": "https://github.com/r-dbi/rmysql", "RemoteRef": "HEAD", "RemoteSha": "386fb585dfad0e9692be076e553927d2b4abb8b1", "Packaged": { "Date": "2026-05-24 06:48:38 UTC", "User": "root" }, "Author": "Jeroen Ooms [aut, cre] (ORCID: ),\nDavid James [aut],\nSaikat DebRoy [aut],\nHadley Wickham [aut],\nJeffrey Horner [aut],\nRStudio [cph]", "Maintainer": "Jeroen Ooms ", "MD5sum": "56b13e8a8725411f7a1f33a0095d74e5", "_user": "r-dbi", "_type": "src", "_file": "RMySQL_0.11.3.tar.gz", "_fileid": "3ca43c8216b0fa47dcff111c0eab480521a4840f7aa1ccca669c36759caa0728", "_filesize": 202357, "_sha256": "3ca43c8216b0fa47dcff111c0eab480521a4840f7aa1ccca669c36759caa0728", "_created": "2026-05-24T06:48:38.000Z", "_published": "2026-05-24T07:01:31.520Z", "_distro": "noble", "_jobs": [ { "job": 77578355638, "time": 106, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7183009299" }, { "job": 77578355640, "time": 103, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7183008927" }, { "job": 77578355645, "time": 112, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7183010016" }, { "job": 77578355635, "time": 112, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7183010050" }, { "job": 77578355637, "time": 69, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7183062509" }, { "job": 77578355632, "time": 151, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "7183053642" }, { "job": 77578355654, "time": 75, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7183057151" }, { "job": 77578355636, "time": 216, "config": "macos-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7183072862" }, { "job": 77578194219, "time": 176, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7182998033" }, { "job": 77578355622, "time": 96, "config": "wasm-release", "r": "4.6.0", "check": "FAIL", "artifact": "" }, { "job": 77578355627, "time": 156, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7183015019" }, { "job": 77578355626, "time": 147, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7183013835" }, { "job": 77578355629, "time": 146, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7183013887" } ], "_buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/r-dbi/rmysql", "_commit": { "id": "386fb585dfad0e9692be076e553927d2b4abb8b1", "author": "Jeroen Ooms ", "committer": "Jeroen Ooms ", "message": "Bump version\n", "time": 1775908656 }, "_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": "r-dbi", "_selfowned": true, "_usedby": 15, "_updates": [ { "week": "2026-10", "n": 1 }, { "week": "2026-14", "n": 2 }, { "week": "2026-15", "n": 1 } ], "_tags": [], "_topics": [ "database", "mysql" ], "_stars": 209, "_contributors": [ { "user": "jeroen", "count": 221, "uuid": 216319 }, { "user": "hadley", "count": 102, "uuid": 4196 }, { "user": "jeffreyhorner", "count": 20, "uuid": 306214 }, { "user": "gagern", "count": 4, "uuid": 190759 }, { "user": "ankane", "count": 3, "uuid": 220358 }, { "user": "ggrothendieck", "count": 2, "uuid": 7840510 }, { "user": "jph98", "count": 2, "uuid": 39952 }, { "user": "rjoomen", "count": 2, "uuid": 1153434 }, { "user": "kongdd", "count": 1, "uuid": 9815742 }, { "user": "gaborcsardi", "count": 1, "uuid": 660288 }, { "user": "jinzhen-lin", "count": 1, "uuid": 14980050 } ], "_userbio": { "uuid": 5695665, "type": "organization", "name": "r-dbi", "description": "R + databases" }, "_downloads": { "count": 45697, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RMySQL" }, "_mentions": 24, "_devurl": "https://github.com/r-dbi/rmysql", "_searchresults": 4408, "_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/readme.html", "extra/readme.md", "extra/RMySQL.html", "manual.pdf" ], "_homeurl": "https://github.com/r-dbi/rmysql", "_realowner": "r-dbi", "_cranurl": true, "_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" ] } ], "_readme": "https://github.com/r-dbi/rmysql/raw/HEAD/README.md", "_rundeps": [ "DBI" ], "_sysdeps": [ { "shlib": "libmysqlclient", "package": "libmysqlclient21", "headers": "libmysqlclient-dev", "source": "mysql", "version": "8.0.45-0ubuntu0.24.04.1", "name": "mysql", "homepage": "http://dev.mysql.com/", "description": "MySQL database client library" } ], "_score": 13.453579334435268, "_indexed": true, "_nocasepkg": "rmysql", "_universes": [ "r-dbi", "jeroen" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.11.3", "date": "2026-05-24T06:50:33.000Z", "distro": "noble", "arch": "aarch64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "e869115dd99d183969b790ed7ad7da97d4d96ac6fde302e3d1c3e6b3b67834db", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.7.0", "os": "linux", "version": "0.11.3", "date": "2026-05-24T06:50:27.000Z", "distro": "noble", "arch": "x86_64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "9f3b21538fdc50c4504ce4e66bf70b2552e69a6116b17bed9b6076e62bd4bc85", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.6.0", "os": "linux", "version": "0.11.3", "date": "2026-05-24T06:50:40.000Z", "distro": "noble", "arch": "aarch64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "abf47e33283898c75bbbe08d7e0181605894fe17c3096cbeef0a449ba14d5a80", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.6.0", "os": "linux", "version": "0.11.3", "date": "2026-05-24T06:50:38.000Z", "distro": "noble", "arch": "x86_64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "cd0080e6588c268d4b46f38bca9f9348590890e0865713a0820dccf6faceaca8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.5.3", "os": "mac", "version": "0.11.3", "date": "2026-05-24T06:59:31.000Z", "arch": "aarch64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "5aaeb39aa734c8b8f00e0e27222e48ed9e975dd05dac6ff3069d9fd9650b8d2f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.5.3", "os": "mac", "version": "0.11.3", "date": "2026-05-24T06:57:44.000Z", "arch": "x86_64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "abe1cc7b59e403ae131998c2eae6ebd7e94c49f354bbfa74036a693c32131f2c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.6.0", "os": "mac", "version": "0.11.3", "date": "2026-05-24T06:58:35.000Z", "arch": "aarch64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "b79ec3c09f26add354f96589c389cb61e72c79c87f8b898c0bf466fa8df60dfa", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.6.0", "os": "mac", "version": "0.11.3", "date": "2026-05-24T07:00:35.000Z", "arch": "x86_64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "b7626ef50f1b2eaa2c840cf623842c44a9ca9ea8694a7611048e26838cfd43cf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.7.0", "os": "win", "version": "0.11.3", "date": "2026-05-24T06:50:01.000Z", "arch": "x86_64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "c2a40eb53282d752b63d522fb1ebef824229b431733839cbf16d65264fecde8f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.5.3", "os": "win", "version": "0.11.3", "date": "2026-05-24T06:49:51.000Z", "arch": "x86_64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "7fce4bfafd386ab0514e44a60f28060d428ec86babf3398b6e951408445d3a06", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" }, { "r": "4.6.0", "os": "win", "version": "0.11.3", "date": "2026-05-24T06:49:50.000Z", "arch": "x86_64", "commit": "386fb585dfad0e9692be076e553927d2b4abb8b1", "fileid": "d0574e854994e87a80179a0a87806208b70b0f75a0913e9f083c9d6f3879e2b9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/r-dbi/actions/runs/26354336260" } ] }