Connecting and disconnecting

Connecting to and disconnecting from databases.

MariaDB() dbConnect(<MariaDBDriver>)

Connect/disconnect to a MariaDB DBMS

Client-flags CLIENT_LONG_PASSWORD CLIENT_FOUND_ROWS CLIENT_LONG_FLAG CLIENT_CONNECT_WITH_DB CLIENT_NO_SCHEMA CLIENT_COMPRESS CLIENT_ODBC CLIENT_LOCAL_FILES CLIENT_IGNORE_SPACE CLIENT_PROTOCOL_41 CLIENT_INTERACTIVE CLIENT_SSL CLIENT_IGNORE_SIGPIPE CLIENT_TRANSACTIONS CLIENT_RESERVED CLIENT_SECURE_CONNECTION CLIENT_MULTI_STATEMENTS CLIENT_MULTI_RESULTS

Client flags

mariadbClientLibraryVersions()

MariaDB Check for Compiled Versus Loaded Client Library Versions

mariadbHasDefault() mariadbDefault()

Check if default database is available.

RMariaDB RMariaDB-package

RMariaDB: Database Interface and MariaDB Driver

Tables

Reading and writing entire tables.

dbAppendTable(<MariaDBConnection>) dbExistsTable(<MariaDBConnection>,<character>) dbListObjects(<MariaDBConnection>) dbListTables(<MariaDBConnection>) dbReadTable(<MariaDBConnection>,<character>) dbRemoveTable(<MariaDBConnection>,<character>) dbWriteTable(<MariaDBConnection>,<character>,<character>) dbWriteTable(<MariaDBConnection>,<character>,<data.frame>)

Read and write MariaDB tables.

Results

More control for sending queries and executing statements.

dbBind(<MariaDBResult>) dbClearResult(<MariaDBResult>) dbFetch(<MariaDBResult>) dbGetStatement(<MariaDBResult>) dbSendQuery(<MariaDBConnection>,<character>) dbSendStatement(<MariaDBConnection>,<character>)

Execute a SQL statement on a database connection.

dbColumnInfo(<MariaDBResult>) dbGetRowCount(<MariaDBResult>) dbGetRowsAffected(<MariaDBResult>) dbHasCompleted(<MariaDBResult>)

Database interface meta-data.

Transactions

Ensuring multiple statements are executed together, or not at all.

dbBegin(<MariaDBConnection>) dbCommit(<MariaDBConnection>) dbRollback(<MariaDBConnection>)

DBMS Transaction Management

SQL

Tools for creating and parsing SQL queries.

dbDataType(<MariaDBConnection>) dbDataType(<MariaDBDriver>)

Determine the SQL Data Type of an S object