Package: RMariaDB 1.3.3

Kirill Müller

RMariaDB: Database Interface and MariaDB Driver

Implements a DBI-compliant interface to MariaDB (<https://mariadb.org/>) and MySQL (<https://www.mysql.com/>) databases.

Authors:Kirill Müller [aut, cre], Jeroen Ooms [aut], David James [aut], Saikat DebRoy [aut], Hadley Wickham [aut], Jeffrey Horner [aut], R Consortium [fnd], RStudio [cph]

RMariaDB_1.3.3.tar.gz
RMariaDB_1.3.3.tar.gz(r-4.5-noble)RMariaDB_1.3.3.tar.gz(r-4.4-noble)
RMariaDB.pdf |RMariaDB.html✨
RMariaDB/json (API)
NEWS

# Install 'RMariaDB' in R:
install.packages('RMariaDB', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/r-dbi/rmariadb/issues

Pkgdown site:https://rmariadb.r-dbi.org

Uses libs:
  • mysql– MySQL database client library
  • c++– GNU Standard C++ Library v3

mysqlcpp

6.59 score 1 stars 11 packages 792 scripts 15k downloads 64 exports 16 dependencies

Last updated 1 months agofrom:85b851d831. Checks:OK: 2. Indexed: no.

TargetResultDate
Doc / VignettesOKDec 19 2024
R-4.5-linux-x86_64OKDec 19 2024

Exports:CLIENT_COMPRESSCLIENT_CONNECT_WITH_DBCLIENT_FOUND_ROWSCLIENT_IGNORE_SIGPIPECLIENT_IGNORE_SPACECLIENT_INTERACTIVECLIENT_LOCAL_FILESCLIENT_LONG_FLAGCLIENT_LONG_PASSWORDCLIENT_MULTI_RESULTSCLIENT_MULTI_STATEMENTSCLIENT_NO_SCHEMACLIENT_ODBCCLIENT_PROTOCOL_41CLIENT_RESERVEDCLIENT_RESERVED2CLIENT_SSLCLIENT_SSL_VERIFY_SERVER_CERTCLIENT_TRANSACTIONSdbAppendTabledbBegindbBinddbCanConnectdbClearResultdbColumnInfodbCommitdbConnectdbCreateTabledbDataTypedbDisconnectdbDriverdbExecutedbExistsTabledbFetchdbGetInfodbGetQuerydbGetRowCountdbGetRowsAffecteddbGetStatementdbHasCompleteddbIsReadOnlydbIsValiddbListFieldsdbListObjectsdbListResultsdbListTablesdbQuoteIdentifierdbQuoteLiteraldbQuoteStringdbReadTabledbRemoveTabledbRollbackdbSendQuerydbSendStatementdbUnloadDriverdbUnquoteIdentifierdbWithTransactiondbWriteTableIdMariaDBmariadbClientLibraryVersionsmariadbDefaultmariadbHasDefaultshow

Dependencies:bitbit64blobclicpp11DBIgenericsgluehmslifecyclelubridatepkgconfigplogrrlangtimechangevctrs

Readme and manuals

Help Manual

Help pageTopics
RMariaDB: Database Interface and MariaDB DriverRMariaDB-package RMariaDB
Client flagsClient-flags 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_RESERVED2 CLIENT_SSL CLIENT_SSL_VERIFY_SERVER_CERT CLIENT_TRANSACTIONS
Determine the SQL Data Type of an S objectdbDataType dbDataType,MariaDBConnection-method dbDataType,MariaDBDriver-method dbDataType_MariaDBConnection dbDataType_MariaDBDriver
Connect/disconnect to a MariaDB DBMSdbConnect,MariaDBDriver-method dbConnect_MariaDBDriver MariaDB
Read and write MariaDB tables.dbAppendTable,MariaDBConnection-method dbAppendTable_MariaDBConnection dbExistsTable,MariaDBConnection,character-method dbExistsTable_MariaDBConnection_character dbListObjects,MariaDBConnection-method dbListObjects_MariaDBConnection_ANY dbListTables,MariaDBConnection-method dbListTables_MariaDBConnection dbReadTable,MariaDBConnection,character-method dbReadTable_MariaDBConnection_character dbRemoveTable,MariaDBConnection,character-method dbRemoveTable_MariaDBConnection_character dbWriteTable,MariaDBConnection,character,character-method dbWriteTable,MariaDBConnection,character,data.frame-method dbWriteTable_MariaDBConnection_character_character dbWriteTable_MariaDBConnection_character_data.frame mariadb-tables
MariaDB Check for Compiled Versus Loaded Client Library VersionsmariadbClientLibraryVersions
Check if default database is available.mariadbDefault mariadbHasDefault
Execute a SQL statement on a database connection.dbBind,MariaDBResult-method dbBind_MariaDBResult dbClearResult,MariaDBResult-method dbClearResult_MariaDBResult dbFetch,MariaDBResult-method dbFetch_MariaDBResult dbGetStatement,MariaDBResult-method dbGetStatement_MariaDBResult dbSendQuery,MariaDBConnection,character-method dbSendQuery_MariaDBConnection_character dbSendStatement,MariaDBConnection,character-method dbSendStatement_MariaDBConnection_character query
Database interface meta-data.dbColumnInfo,MariaDBResult-method dbColumnInfo_MariaDBResult dbGetRowCount,MariaDBResult-method dbGetRowCount_MariaDBResult dbGetRowsAffected,MariaDBResult-method dbGetRowsAffected_MariaDBResult dbHasCompleted,MariaDBResult-method dbHasCompleted_MariaDBResult result-meta
DBMS Transaction ManagementdbBegin,MariaDBConnection-method dbBegin_MariaDBConnection dbCommit,MariaDBConnection-method dbCommit_MariaDBConnection dbRollback,MariaDBConnection-method dbRollback_MariaDBConnection transactions